... Count, <<< Positive Values minus Negative Values >>> ...

[Guest]

I have a column which contains 20 cells with 4 negative values and 12
positive values.

I want to do a count, but I only want a count the positive valued cells
minus the negative valued cells. so the result of the count in this example
would be 12-4=8.

How do I write my function?

Darrell

 

[Paul Sheppard]

I have a column which contains 20 cells with 4 negative values and 12
positive values.

I want to do a count, but I only want a count the positive valued
cells
minus the negative valued cells. so the result of the count in this
example
would be 12-4=8.

How do I write my function?

Darrell

Hi Darrell

Try this > =SUM(COUNTIF(A1:A20,">0")-COUNTIF(A1:A20,"<0"))

This will ignore 0's, blanks and text

 

[Guest]

You can try this:

=SUM((COUNTIF(A1:A20,">0")-(COUNTIF(A1:A20,"<0"))))

This counts the positive values, and the negative values, and subtracts them.

Hope this helps

 

[Guest]

=COUNTIF(A:A,">0")

or, if you prefer,

=COUNT(A:A)-COUNTIF(A:A,"<=0")

Vaya con DIos,
Chuck, CABGx3

 

[Ron de Bruin]

Hi Dr. Darrell

Try this
=COUNTIF(A1:A20,">0")