count column with numbers greater than zero

**rowneyg** · 04-19-2015, 10:06 AM

I am trying to count columns containing numbers that are greater than zero only

**newdoverman** · 04-19-2015, 10:10 AM

Something like this will do what you want

Formula:

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

**rowneyg** · 04-20-2015, 01:54 AM

Many thanks for quick response

**newdoverman** · 04-19-2015, 10:12 AM

After re-reading your question, are you wanting to count the columns only and not the contents?

**newdoverman** · 04-19-2015, 10:31 AM

This will count columns that have values >0 even if they also have values of 0 or less. Expand the formula to include columns and rows as required.

Formula:

=SUM(IF(COUNTIF(A1:A50,">0")>0,1,0)+IF(COUNTIF(B1:B50,">0")>0,1,0)+IF(COUNTIF(C1:C50,">0")>0,1,0))

**newdoverman** · 04-20-2015, 09:03 AM

Thank you for the feedback.

Re: count column with numbers greater than zero