 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008needing to calculate entries, but no the spaces in some cells
Hello, I am trying to develop a log in EXCEL to which persons sign off after completing a task. The problem comes that some users are using the drag and fill option then using the space bar to clear their initials for the uncompleted tasks that may be in line. Using the COUNTA function counts the space as a filled cell, therefore i get incorrect counts. I am unable to figure out how to use the trim and COUNTA at the same time. Thank you in advance for any help... Sorry, I forgot to add: Also within the column, are rows that are NOT to be included in the tally. So I have to use multiple ranges for the one outcome. There is where another problem resides, I am unable to figure how to use multiple commands for one result. > Hello, > I am trying to develop a log in EXCEL to which persons sign off after [quoted text clipped - 7 lines] > > Thank you in advance for any help... One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =SUM(--(LEN(TRIM(A1:A10))>0)) > Hello, > I am trying to develop a log in EXCEL to which persons sign off after [quoted text clipped - 7 lines] > > Thank you in advance for any help... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.