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

[Lollycat]

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!

[Ruthki]

try

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


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

R

[Knold10]

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]

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

[Peo Sjoblom]

Or even

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:437FECA1.29A886DA@verizonXSPAM.net...
> 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

[Ron Rosenfeld]

On Sat, 30 Jul 2005 07:00:03 -0700, "Lollycat"
<Lollycat@discussions.microsoft.com> 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

[Lollycat]

Thank you very much!!

"Ron Rosenfeld" wrote:

> On Sat, 30 Jul 2005 07:00:03 -0700, "Lollycat"
> <Lollycat@discussions.microsoft.com> 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
>

[R.VENKATARAMAN]

use <sumif> see help


Lollycat <Lollycat@discussions.microsoft.com> wrote in message
news:F3F3ECF4-8DBD-4E8F-A852-54A32DEAD592@microsoft.com...
> 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!