Can you give some more details about the
kind of test you want to perform on Col_Z?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)



"plb2862" wrote in message
...
I've been trying to sum multiple columns where a condition does not exeist
in one of the columns. Example: columns x, y & z where z doesn't contain
"this condition".

I can understand that these work:
=SUMPRODUCT((condition1)*(condition2)*(condition3) )
and even =SUMPRODUCT(--(condition1),--(condition2),--(condition3))
but I can't understand how to get to my desired results. Would I write
the formula like this?
=SUMPRODUCT((condition1)*(condition2)-(condition3))
=SUMPRODUCT(--(condition1),--(condition2),-(condition3))

TIA