Cells with no data

[dakotablu]

This is my formula:

=((D41)>0)+((D61)>0)+((D81)>0)+((D101)>0)+((D121)>0)+((D141)>0)+((D161)>0)+((D181)>0)&$T$2&((D41)=0)+((D61)=0)+((D81)=0)+((D101)=0)+((D121)=0)+((D141)=0)+((D161)=0)+((D181)=0)&$T$2&((D41)<1)+((D61)<1)+((D81)<1)+((D101)<1)+((D121)<1)+((D141)<1)+((D161)<1)+((D181)<1)

Basically, I'm using a set of cells within columns to show the amount of
numbers that are >0, =0, or <0. If a selected cell has no data how do I make
sure that it is not counted as a positive number (>0)

Thanks

 

[Shane Devenshire]

Hi,

You might consider

Counts all cell >0 =COUNTIF(A1:A20,">0")
Counts all cell <0 =COUNTIF(A1:A20,"<0")
Counts all cell = 0 =COUNTIF(A1:A20,"=0")