Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
needing 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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
needing to calculate entries, but no the spaces in some cells
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. "joflo65" wrote: 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... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
needing to calculate entries, but no the spaces in some cells
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=SUM(--(LEN(TRIM(A1:A10))0)) In article , joflo65 wrote: 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP needing to match two cells | Excel Worksheet Functions | |||
Want temporary color in cells needing attention | Excel Discussion (Misc queries) | |||
How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
find the same entries and calculate sum | Excel Worksheet Functions | |||
Any way to calculate an average for more than 30 entries? | Excel Worksheet Functions |