A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Do I use an IF function?



 
 
Thread Tools Display Modes
  #1  
Old June 11th, 2004, 09:56 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 11th, 2004, 10:03 PM
Domenic
external usenet poster
 
Posts: n/a
Default 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!

  #4  
Old June 11th, 2004, 10:04 PM
Jason Morin
external usenet poster
 
Posts: n/a
Default 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  
Old June 11th, 2004, 10:06 PM
Jay
external usenet poster
 
Posts: n/a
Default 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  
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!
.

  #7  
Old June 11th, 2004, 10:13 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 11th, 2004, 10:18 PM
Soo Cheon Jheong
external usenet poster
 
Posts: n/a
Default Do I use an IF function?

Hi,


Negative (-) numbers:

=SUMIF(A1:A100,"0")



--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^ąŻ^
--


  #9  
Old June 12th, 2004, 01:15 PM
mips
external usenet poster
 
Posts: n/a
Default 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  
Old June 12th, 2004, 01:25 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.