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

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")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dakotablu" wrote:

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