Croydon_Poppy
New Member
- Joined
- Apr 23, 2013
- Messages
- 2
Hi
I am using the following formula
=SUMPRODUCT((Index!$A$1:$A$5000=Main!C4)*(Index!$B$1:$B$5000=Main!C5)*(Index!$C$1:$C$5000=Main!C6)*(Index!$D$1:$D$5000=Main!C7)*(Index!$E$1:$E$5000=Main!C8)*(Index!$F$1:$F$5000=Main!C9)*Index!$G$1:$G$5000)
This works as long as one of the (C4, C5, C6, C7, C8, C9) cells has a value. But this formula stops working when any of the above cells becomes a null (is left blank). Can someone please help me with this?
Thanks in advance.
I am using the following formula
=SUMPRODUCT((Index!$A$1:$A$5000=Main!C4)*(Index!$B$1:$B$5000=Main!C5)*(Index!$C$1:$C$5000=Main!C6)*(Index!$D$1:$D$5000=Main!C7)*(Index!$E$1:$E$5000=Main!C8)*(Index!$F$1:$F$5000=Main!C9)*Index!$G$1:$G$5000)
This works as long as one of the (C4, C5, C6, C7, C8, C9) cells has a value. But this formula stops working when any of the above cells becomes a null (is left blank). Can someone please help me with this?
Thanks in advance.