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!