Kentman
Active Member
- Joined
- Apr 26, 2010
- Messages
- 260
I have the following formula:
=SUMPRODUCT(--(Hillrise!$AF$2:$AF$2000=$B27),--(Hillrise!$AE$2:$AE$2000=MONDAY))
which works great however, i want to use the information in B26 (which can change) rather than have it hard coded in the formular - but I can't get this to work:
=SUMPRODUCT(--(INDIRECT(B26&"!$AF$2:$AF$2000"=$B27)),--(INDIRECT(B26&"!$AE$2:$AE$2000"=MONDAY)))
It returns #REF
What am I doing wrong?
=SUMPRODUCT(--(Hillrise!$AF$2:$AF$2000=$B27),--(Hillrise!$AE$2:$AE$2000=MONDAY))
which works great however, i want to use the information in B26 (which can change) rather than have it hard coded in the formular - but I can't get this to work:
=SUMPRODUCT(--(INDIRECT(B26&"!$AF$2:$AF$2000"=$B27)),--(INDIRECT(B26&"!$AE$2:$AE$2000"=MONDAY)))
It returns #REF
What am I doing wrong?