sum question

[Bart B]

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

 

[Ardus Petus]

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

HTH

 

[Dave Peterson]

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

Is one way.

"Bart B

 

[Bart B]

thank, just what I needed

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

HTH

 

[Bob Phillips]

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.

--
HTH

Bob Phillips

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