mcarter973
Board Regular
- Joined
- Mar 24, 2002
- Messages
- 83
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 have the following formula:
=sumproduct((month(sheet1!A10:L10)<=month(sheet1!A1))*(sheet1!A20:L20)