may be
=SUMPRODUCT(--(C1:C5="X"),--(D1:D5="Y"),--(E1:E5<"Z"),--(F1:F5))
-via135

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!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1