sum question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bart B - 11 Jul 2006 15:36 GMT

Here is what I have

$130.39
$52.90 CR
$16.00
$84.32
$20.00 CR

I would like to be able to get the sum of these numbers, but the numbers
with a CR(credit) by it I would like to subtract from the total. So the
total would be $157.81. The dollar amount and the CR's are in differnt
columns.

thanks

Reply to this Message

Ardus Petus - 11 Jul 2006 15:42 GMT

=SUMIF(B:B,"<>CR",A:A)-SUMIF(B:B,"CR",A:A)

HTH
--
AP

> Here is what I have
>
[quoted text clipped - 10 lines]
>
> thanks

Reply to this Message

Bart B - 11 Jul 2006 16:00 GMT

thank, just what I needed

> =SUMIF(B:B,"<>CR",A:A)-SUMIF(B:B,"CR",A:A)
>
[quoted text clipped - 16 lines]
>>
>> thanks

Reply to this Message

Dave Peterson - 11 Jul 2006 15:50 GMT

=SUMIF(B1:B5,"",A1:A5)-SUMIF(B1:B5,"CR",A1:A5)

Is one way.

"Bart B

> Here is what I have
>
[quoted text clipped - 10 lines]
>
> thanks

Signature

Dave Peterson

Reply to this Message

Bob Phillips - 11 Jul 2006 16:06 GMT

If the CR is just formatting, you could use

=SUM(ABS(A1:A10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Signature

HTH

Bob Phillips

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

> Here is what I have
>
[quoted text clipped - 10 lines]
>
> thanks

Reply to this Message

Rate this thread: