Previous Thread

7/11/2006 9:36:34 AM    sum question
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



7/11/2006 9:50:40 AM    Re: sum question
=SUMIF(B1:B5,"",A1:A5)-SUMIF(B1:B5,"CR",A1:A5) 
 
Is one way. 
 
"Bart B 
 
-- 
 
Dave Peterson

7/11/2006 10:00:30 AM    Re: sum question
thank, just what I needed 
 
"Ardus Petus" <ardus.petus@laposte.net> wrote in message 
 
news:%23oORehPpGHA.2400@TK2MSFTNGP03.phx.gbl...

7/11/2006 4:06:04 PM    Re: sum question
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) 
 
"Bart B menard.com>" <bbailey@<REMOVECAPS> wrote in message 
 
news:%23CnkqdPpGHA.3584@TK2MSFTNGP05.phx.gbl...

7/11/2006 4:42:54 PM    Re: sum question
=SUMIF(B:B,"<>CR",A:A)-SUMIF(B:B,"CR",A:A) 
 
HTH 
 
-- 
 
AP 
 
"Bart B menard.com>" <bbailey@<REMOVECAPS> a écrit dans le message de news: 
 
%23CnkqdPpGHA.3584@TK2MSFTNGP05.phx.gbl...