View Single Post
  #6  
Old June 11th, 2004, 10:10 PM
external usenet poster
 
Posts: n/a
Default Do I use an IF function?

Wow that was fast!

Your formula works just fine!

Thank you very much!

-----Original Message-----
Hi
try
=SUMIF(A:A,"0")

and for the positive numbers
=SUMIF(A:A,"0")


--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Here is what I'm trying to do. I'm making an expense
record chart. I am entering a negative (-) number for
items paid with a credit card and a positve (+) number
for items paid with cash. Hence, I will have both
negative AND positive numbers in the same column (I
cannot use two separate columns, for lack of space). I
would like to know a formula or use an IF function that
will total up the negative (-) numbers only. Does

anyone
know how to do this, or if it is even possible?

Thanks!
.