Counting Items

J

Jakobshavn Isbrae

I agree with your judgement on this. I was using an additional column with
len(a1) in the column. I was then using countif to count how many items in
this additional column were greater than zero.

Rick's single equation is a whole lot easier.

and by the way thanks to everyone who took the time to help me out on a
Sunday.
 
H

Harlan Grove

Jakobshavn Isbrae said:
How can I count the number of items in a column whose length exceeds zero?
Click to expand...

Most efficient,

=ROWS(Range)*COLUMNS(Range)-COUNTBLANK(Range)

This will count every cell except truly blank cells (in the ISBLANK
sense) and cells evaluating to "". If you want to count only text
cells with 1 or more characters and cells containing numbers, try

=COUNT(Range)+COUNTIF(Range,"?*")
 

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

Adding recognised Zeros 5
COUNT IF 1
How do I count only if either/ or exist 5
Counting Filtered Results Using Autofilter 2
Count Num of unique items in col? by 3 criteria 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Row Count 3
Counting occurrences of products in a master list 7

Top