=COUNTIF(D4:D29,">0")

[Mike]

I need this formula to also count negative numbers

 

[RagDyeR]

Have you tried this:

=COUNTIF(D429,"<0")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I need this formula to also count negative numbers

 

[Dave Peterson]

Maybe...

=COUNTIF(D429,"<>0")

I need this formula to also count negative numbers

 

[Mike]

I need this do count both negative and positive

 

[Mike]

I guess i need to have THE ABS value

 

[Mike]

I need them to by 1 EXample

1 2 4 5 10 11 15 16 -19 24 0 -13 0 2 0 -9 0 0 0
0 0 -3 0 1 0 -46 1 - 0 0 -11 0 -120 0 0 0 5 -1 1 0
Total 4 2 3 3 4 3 4

 

[Bob Phillips]

=SUM(D429)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Jerry W. Lewis]

=COUNTIF(D429,"<>0") will count anything not zero (empty cells, text,
booleans, errors, etc). It also behaves strangely on sheets where the last
row ever used is <29.

To count only positive or negative numbers, use
=COUNTIF(D429,">0")+COUNTIF(D429,"<0")

Jerry

 

[Dave Peterson]

Good point.

Another alternative...
=COUNT(D429)-COUNTIF(D429,0)

Which will distiguish between text 0 ('0) and the number 0.

 

[Mike]

TY Very Much That Worked Great

Good point.

Another alternative...
=COUNT(D429)-COUNTIF(D429,0)

Which will distiguish between text 0 ('0) and the number 0.