They can be any columns--well, you can't use the whole column--but the order
isn't important.



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

--

Dave Peterson