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