needing to calculate entries, but no the spaces in some cells

  • Thread starter Thread starter joflo65
  • Start date Start date
J

joflo65

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.
 
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(--(LEN(TRIM(A1:A10))>0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting cell entries 4
Counting nonblank and non white space cells 6
count nonblank cells 3
Determining number of entries in a table 3
formula in pivot tables involving counting text cells 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Calculating cells with text only 1
finding the maximum number of used cells in any column of a table 6

Back
Top