If this was me, I would do the following:

-- insert a helper column
-- use a Vlookup formula to determine if the cell is in the list
(=if(isna(vlookup(a1,range,1,false)),"include","om it")
-- do the sumif on the helper column if it equals "include"

Others may come up with better ideas.

--
Regards,
Fred


"Pete" wrote in message
...
I need to total large column of data, but I need to omit the rowif certain
letters appear in that row.

sumif column A does not equal one of these:
muc,str,cph,mad,bcn,lgw,dub,ams,eze,gru,gig,mex,cu n,lim,ccs,zrh,or fra

Can anyone tell me how to accomplish this formula? I am desperate.

Thanks,

Pete