Jemma Atkinson
Well-known Member
- Joined
- Jul 7, 2008
- Messages
- 509
Hi, is there an alternative formula to sumproduct where i can use named ranges? The below wont work for named range
=SUMPRODUCT(--(Over2day!$Z$7:$Z$10000=Rec_Criteria!C14),--(Over2day!$H$7:$H$10000>=2),--(Over2day!$H$7:$H$10000<=29))
=SUMPRODUCT(--(Over2day!$Z$7:$Z$10000=Rec_Criteria!C14),--(Over2day!$H$7:$H$10000>=2),--(Over2day!$H$7:$H$10000<=29))