If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Do I use an IF function?
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! 
Ads 
#2




Do I use an IF function?
Hi,
Try, =SUMIF(C2:C10,"0") Hope this helps! In article , 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! 
#3




Do I use an IF function?
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! 
#4




Do I use an IF function?
Let's assume your expenses are in column A:
=SUMIF(A:A,"0") HTH Jason Atlanta, GA Original Message 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! . 
#5




Do I use an IF function?
... 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. ... One way: =SUMIF(A1:A9,"0") (Adjust to your specific range of cells.) 
#6




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! . 
#7




Do I use an IF function?
Thanks everyone!
All of your formulas are correct. Original Message 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! . 
#8




Do I use an IF function?
Hi,
Negative () numbers: =SUMIF(A1:A100,"0")  Regards, Soo Cheon Jheong Seoul, Korea _ _ ^ąŻ^  
#9




Do I use an IF function?
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. "Frank Kabel" wrote in message ... Hi try =SUMIF(A:A,"0") and for the positive numbers =SUMIF(A:A,"0") 
#10




Do I use an IF function?
Hi
use SUMPRODUCT. e.g. =SUMPRODUCT((A1:Z1="cond_1"),(A2:Z2="cond_2"),A3:Z3)  Regards Frank Kabel Frankfurt, Germany mips wrote: 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. "Frank Kabel" wrote in message ... Hi try =SUMIF(A:A,"0") and for the positive numbers =SUMIF(A:A,"0") 
Thread Tools  
Display Modes  

