Formula Count Entries in a range if another range is = 1 and Another = Monday

Hi,

I have this formula that is suppose to count the amount of orders done by first shift and in this case on Monday.

So I am trying to use this formula:

Please Login or Register  to view this content.

Col 6 has the orders
Col 5 has the shift they worked
Col 16 has the weekday


Row 7 Col 6 I enter order # 12345
Row 8 Col 6 I enter order # 45678
Row 9 Col 6 I enter order # 55555

For all 3 rows listed above Col 5 = 1 and col 16 = Monday

The results I want should be 3 however I am getting 6, I am using this same formula to sum up the lines and cases picked and it works fine.I just changed the col its looking in.

Can someone advise?

Thank You, Mike

You have a comma missing

=SUMPRODUCT(--(INDEX(MyRange,0,6)<>""),--(INDEX(MyRange,0,5)=1) , --(INDEX(MyRange,0,16)="Monday"))