Hello Excel Users and Experts,

With:

Sumproduct((array1=condition1)*(array2=condition2)*(array3))

Can array1 be column A, array2 be column C and array3 be column B? Or does
2 have to be to the right of 1 and 3 to the right of 2?

I could have swore I returned an array3 that was between 1 and 2 once upon a
time, but today I "swore" because I could not make that work. Moved the
array3 info to the right of 1 and 2, bingo, success.

Thanks folks.
Regards,
Howard