Do I use an IF function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
... 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
would like to know a formula or use an IF function that
will total up the negative (-) numbers only. ...
Click to expand...

One way:
=SUMIF(A1:A9,"<0")

(Adjust to your specific range of cells.)
 
Hi,


Negative (-) numbers:

=SUMIF(A1:A100,"<0")



--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--
 
Hi folks

Is there a way to test for multiple conditions before summing up? Something
like the function "sumif" but be able to test for more than one conditions.

For example, I have condition one on say row A1:Z1, condition two on row
A2:Z2, and the data that I want to sum up on row A3:Z3. Is there a
worksheet function in Excel that allows me to sum up the data contained
somewhere in row A3:Z3 only when the conditions of the respective column in
the first and second row are true.

Thanks.
 
Back
Top