How to add number of non-blank cells in a range and leave blank if 0

[OccamsShaver]

Hi-
This is probably easy for the experienced folks here.
I am simply wanting to calculate the number of nonblank cells (numerical) between columns F2:BF2 and want to leave the new cell blank if all of the cells in that range are blank.

Any suggestions?

Thank you!

OS

 

[Joe4]

Try:

=IF(COUNTBLANK(F2:BF2)=53,"",COUNT(F2:BF2))

 

[OccamsShaver]

Thank you, Joe4. I realize that I was not clear enough in my post.
What I am looking for is a formula that will produce a blank cell if all cells from F2:BF2 are blank. Otherwise, the formula should count the number of cells in the range that are >0.

 

[Joe4]

Just one minor modification then:

=IF(COUNTBLANK(F2:BF2)=53,"",COUNTIF(F2:BF2,">0"))

The one thing you haven't addressed is what you want to happen if there are any text entries or numerical values equal to or less than 0.
The formula above will just ignore those values.

 

[shaowu459]

=text(countif(f2:bf2,">0"),"0;;")

 

[OccamsShaver]

Is this correct?
=IF(COUNTBLANK(F3:BF3)=53,"",COUNTIF(F3:BF3,">0"))

 

[Joe4]

=text(countif(f2:bf2,">0"),"0;;")

Just be aware that will return a Text entry, and not a Numeric one.
That could be an issue if you are looking to use this count in any calculations or sorting.

 

[Joe4]

Is this correct?
=IF(COUNTBLANK(F3:BF3)=53,"",COUNTIF(F3:BF3,">0"))

That looks just like the formula I posted above, except you are referencing row 3 instead of row 2.
(All your previous posts mentioned row 2, not row 3).

 

[shaowu459]

yes, a more practical solution is format cells with "0;;".

 

[OccamsShaver]

Oops, thank you very much. I did not see any of those replies before I posted that last formula.