# =COUNTIF(A1;A10.....value is greater than zero?

This is a discussion on =COUNTIF(A1;A10.....value is greater than zero? within the Excel Questions forums, part of the Question Forums category; Hi there, I am wondering how to finish this formula off, I want to count the number of cells in ...

1. ## =COUNTIF(A1;A10.....value is greater than zero?

Hi there,

I am wondering how to finish this formula off,

I want to count the number of cells in a list that have a value that is greater than zero?

Many thanks,

Graham.

2. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

Hello,

=COUNTIF(A1:A10,">0")

3. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

This is perfect....thankyou!

4. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

Perfect is 100% correct. This will save me a lot of time!

5. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

lol

Was wondering why this thread has over 9,700 views...

Nice bump

6. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

I think it has this many page views because the formula does not always work.

7. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

you're a star!! this saves me countless minutes

8. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

strange that this requires the ""...

9. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

Hello,

=COUNTIF(A1:A10,">0")

How could i do this if the cells to count if greater than 0 are not in a range. I need to count how many cells are greater than 0 from the flowing cells:
B15,
B19,
B23,
B27,
B31,
B35,
B39,
B43

Any answers in those cells greater than 0 should be shown in cell B47.

Many thanks

10. ## Re: =COUNTIF(A1;A10.....value is greater than zero?

Originally Posted by b19upj
Any answers in those cells greater than 0 should be shown in cell B47.
Welcome to the board!

Try this is cell B47:

=SUMPRODUCT(--(MOD(ROW(B15:B43)-ROW(B15)+1,4)=1),--(B15:B43>0))

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•