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" 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" 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  |