Count values

[laxster]

I have a spreadsheet with a wide range of values. I'd like to count the cells which have values, regardless of what the value may be.

I'm not looking to count blank values, and I'm not looking at counting specific values. Just the number of cells which have a value in them, regardless of what it is.

What function would I use for that?

 

[rainman89]

Can you just use the count function?

I created a test sheet using

1_2_3_456 and used count to get the total of 6...

_ are blanks

Or am i missing something?

 

[laxster]

No, it doesn't work. The cells contain a combination of text and values. Some cells may read "no" while other cells will see a date. I need to count both in the same formula.

 

[rainman89]

How about a CountA function?

=COUNTA(A1:K1)

 

[Brianwarnock]

Help shows that that Count counts numbers, counta counts non EMPTY cells, but note this is not the same as nonBlank, a Blank cell ie one that has say been cleared with the space bar will count, to find if you have any of those use CountBlank.

Brian