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]

The reason why I included the COUNTBLANK is to account for the possibility of text or negative numbers.
If there was just blanks and those values, it would differentiate from all blanks, and return a value of 0 instead of a blank.

Which one makes more sense depends on whether this possibility exists, and how they want to handle that possibility.

 

[OccamsShaver]

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

Can you please explain this? Thanks

 

[Joe4]

Can you please explain this? Thanks

It is just a Custom Number Format that hides any value less than or equal to zero.
You could format your cells that way to hide those values.

 

[shaowu459]

for example, formula in A1 is =countif(B:B,">0")

Select A1, right click-[format cells]-[custom], in the textbox on the right side, enter 0;;

if =countif(B:B,">0") returns a value >0, A1 will show the number; if =countif(B:B,">0") returns 0, A1 just seems like a blank cell while stored the number 0.