Thread: SUMPRODUCT question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] engteng@gmail.com is offline
external usenet poster
  
Posts: 3
Default SUMPRODUCT question
=SUMPRODUCT(--('Raw Data'!$E1:$E65535<=4))

How do I change the 65535 in above formula to dynamic variable?


Regards,
Tee
Reply With QuoteReply With Quote