Summing across columns while skipping some columns

  • Thread starter Thread starter JAG
  • Start date Start date
J

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
 
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
 
Back
Top