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

[Dr. Darrell]

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

[Robbo]

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


"Dr. Darrell" wrote:

> 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

[CLR]

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

or, if you prefer,

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

Vaya con DIos,
Chuck, CABGx3





"Dr. Darrell" wrote:

> 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

[Ron de Bruin]

Hi Dr. Darrell

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dr. Darrell" <[email protected]> wrote in message news:[email protected]...
>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