Try something like
=IF(AND(SUM(C1:C100)=X,SUM(D1:D100)=Y,FALSE(SUM(E1 :E100)=Z)),SUM(C1:C100)+SUM(D1:D100),"")

There may be a more concise way to do that, but I think it's what you're
looking for.

Dave
--
Brevity is the soul of wit.


"Leslie M" wrote:

I would like to set up a formula that would read something like... add
c1:c100 if they equal X and d1:d100=Y but e1:e100 does not equal Z. I am
familiar with SUMPRODUCT to get the first two parts of the equation, but
don't know how to make it do a "not this". Any help would be VERY MUCH
appreciated!! Thanks!