sumproduct

[mcarter973]

can a derivative of "sumproduct" be used to lookup column data.

i have the following formula:

=sumproduct((month(sheet1!A10:L10)<=month(sheet1!A1))*(sheet1!A20:L20)

 

[Aladin Akyurek]

On 2002-03-25 07:29, mcarter973 wrote:
can a derivative of "sumproduct" be used to lookup column data.

i have the following formula:

=sumproduct((month(sheet1!A10:L10)<=month(sheet1!A1))*(sheet1!A20:L20)

I expect this formula to work if you add a closing paren at the end.