KP_SoCal
Board Regular
- Joined
- Nov 17, 2009
- Messages
- 116
I’m struggling to come up with a solution for this. I have two questions which I will create separate posts for. For this post, here’s the formula I’m working with:
=SUMPRODUCT((AllocatedVeh!$A$2:$A$65000=Manifest!C8)*(AllocatedVeh!$C$2:$C$65000=Manifest!D8)*(AllocatedVeh!$F$2:$F$65000=Manifest!G8)*(AllocatedVeh!$I$2:$I$65000))
I need my SUMPRODUCT function formula to SKIP criteria in certain instances. For instance, if Manifest!C8 = “TEXTILE”, I want to skip (AllocatedVeh!$A$2:$A$65000=Manifest!C8) as being a part of the criteria in summing (AllocatedVeh!$I$2:$I$65000).
I hope this makes sense. Thanks so much for any help you can provide!
=SUMPRODUCT((AllocatedVeh!$A$2:$A$65000=Manifest!C8)*(AllocatedVeh!$C$2:$C$65000=Manifest!D8)*(AllocatedVeh!$F$2:$F$65000=Manifest!G8)*(AllocatedVeh!$I$2:$I$65000))
I need my SUMPRODUCT function formula to SKIP criteria in certain instances. For instance, if Manifest!C8 = “TEXTILE”, I want to skip (AllocatedVeh!$A$2:$A$65000=Manifest!C8) as being a part of the criteria in summing (AllocatedVeh!$I$2:$I$65000).
I hope this makes sense. Thanks so much for any help you can provide!
