Summing across columns while skipping some columns

[JAG]

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

 

[Bernard Liengme]

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

 

[Ashish Mathur]

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com