SUMPRODUCT question
Thas been tested and does work
=SUMPRODUCT(--(INDIRECT("'Raw Data'!E2:E"&B4)<=4))
--
Wag more, bark less
" wrote:
I have tested but not work #REF! error.
On Jun 11, 9:51 am, Brad wrote:
Untested but should work - assuming that c5 has the dynamic number in it.
=SUMPRODUCT(--(indirect("Raw Data'!$E1:$E"&c5)<=4))
--
Wag more, bark less
" wrote:
=SUMPRODUCT(--('Raw Data'!$E1:$E65535<=4))
How do I change the 65535 in above formula to dynamic variable?
Regards,
Tee- Hide quoted text -
- Show quoted text -
|