In Excel, how do I only add numbers in a row that are over 0?
 

In my monthly spreadsheet, I have 31 rows and 8 columns in which I have both
negative and positive numbers. Each row must have a total to the right, but
I only want the positive numbers to be taken into account. However, the
negative numbers are not always in the same column. Any way I can do this?
Thank you!

use <sumif see help


Lollycat wrote in message
...
In my monthly spreadsheet, I have 31 rows and 8 columns in which I have
both
negative and positive numbers. Each row must have a total to the right,
but
I only want the positive numbers to be taken into account. However, the
negative numbers are not always in the same column. Any way I can do
this?
Thank you!

On Sat, 30 Jul 2005 07:00:03 -0700, "Lollycat"
wrote:

In my monthly spreadsheet, I have 31 rows and 8 columns in which I have both
negative and positive numbers. Each row must have a total to the right, but
I only want the positive numbers to be taken into account. However, the
negative numbers are not always in the same column. Any way I can do this?
Thank you!

=SUMIF(rng,"0")


--ron

try

=SUMIF(B3:I3,"0",B3:I3)


where b3:I3 are the range you are testing and summing.

R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391529

Thank you very much!!

"Ron Rosenfeld" wrote:

On Sat, 30 Jul 2005 07:00:03 -0700, "Lollycat"
wrote:

In my monthly spreadsheet, I have 31 rows and 8 columns in which I have both
negative and positive numbers. Each row must have a total to the right, but
I only want the positive numbers to be taken into account. However, the
negative numbers are not always in the same column. Any way I can do this?
Thank you!

=SUMIF(rng,"0")


--ron

In Excel, how do I only add numbers in a row that are over 0?
 

I just read this. How about adding the negative numbers?

"Ruthki" wrote:


try

=SUMIF(B3:I3,"0",B3:I3)


where b3:I3 are the range you are testing and summing.

R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391529

In Excel, how do I only add numbers in a row that are over 0?
 

Just reverse that inequity sign:

=SUMIF(B3:I3,"<0",B3:I3)



Knold10 wrote:

I just read this. How about adding the negative numbers?

"Ruthki" wrote:


try

=SUMIF(B3:I3,"0",B3:I3)


where b3:I3 are the range you are testing and summing.

R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391529



--

Dave Peterson