Well, I regrouped with Dave and John's advice. It works as advertised... I
must of had my columns values screwed up or perhaps the lookup values...???

Rats!!! I'm smarter than this but went duhhhhh...here.

Thanks Dave and John... will report back with the next brain cramp. <bg

Thanks again.

Regards,
Howard

"L. Howard Kittle" wrote in message
. ..
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