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

[fugeg70]

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.

 

[onlyadrafter]

Hello,

Does this suit your needs?

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

 

[fugeg70]

This is perfect....thankyou!

 

[jgandert]

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

 

[Rusty]

lol

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

Nice bump

 

[Churchy LaFemme]

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

 

[dozzydozz]

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

 

[puzzledone]

strange that this requires the ""...

 

[b19upj]

Hello,

Does this suit your needs?

=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

 

[FormR]

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))