Please help with count function

R

rhphoto

I am trying to use the count formula for a range of three cells whic
each contain an underlying sumproduct formula. Is it posssible to us
the count formula to show the results of the data that appears in th
cells instead of the formulas? In other words, if there are only tw
cells which display visible numbers, the count formula still shows
result of 3.

Any help would be greatly appreciated!
 
B

Biff

Hi!

COUNT counts cells that contain numeric values. If as you
say, the result of the COUNT is 3 yet you only see 2 cells
with numbers in them then perhaps the one cell that
appears blank is really a zero and you have set zero
values to not be displayed.

If you only want to count values >0:

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

OR, if you want to count all values, including negatives,
except zeros:

=COUNTIF(A1:A3,"<>0")

Biff
 
M

mangesh_yadav

could you give example, especially of the cell which shouldn't be
counted. What does it contain. Count has other variants which could be
used

- Mangesh
 
Top