Prev: SUMPRODUCT to substiute array formula
Next: Sum multiple vlookup returns across multiple columns
From: JAG on 26 Feb 2010 08:15
Does anyone know of an easy way to accomplish this?

In the example below, I do not wish to add the values in columns G18 and J18.
=SUMIF(F18:L18,"<>#N/A",F18:L18)

Thanks in advance for any replies.
Joe
From: Bernard Liengme on 26 Feb 2010 08:51
How about
=SUMIF(F18:L18,"<>#N/A")-SUMIF(G18,"<>#N/A")-SUMIF(J18,"<>#N/A")
Note the third argument is not needed since you are summing the same range
as you are testing.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

"JAG" <JAG(a)discussions.microsoft.com> wrote in message
news:37DCC642-0D35-4D2A-A4A2-AD678DF5FC56(a)microsoft.com...
> Does anyone know of an easy way to accomplish this?
>
> In the example below, I do not wish to add the values in columns G18 and
> J18.
> =SUMIF(F18:L18,"<>#N/A",F18:L18)
>
> Thanks in advance for any replies.
> Joe

From: Ashish Mathur on 28 Feb 2010 09:58
Hi,

Try this

=sumif(F18:L18,">=0")+sumif(F18:L18,"<=0")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JAG" <JAG(a)discussions.microsoft.com> wrote in message
news:37DCC642-0D35-4D2A-A4A2-AD678DF5FC56(a)microsoft.com...
> Does anyone know of an easy way to accomplish this?
>
> In the example below, I do not wish to add the values in columns G18 and
> J18.
> =SUMIF(F18:L18,"<>#N/A",F18:L18)
>
> Thanks in advance for any replies.
> Joe

 | 
Pages: 1
Prev: SUMPRODUCT to substiute array formula
Next: Sum multiple vlookup returns across multiple columns