Hi Everyone,
We have a daily log of the number of parcels picked up by our customers. The number of parcels to be picked up ranges from 0 to a maximum of 5 per day.
Customers are each assigned a pick-up day (Column C) if they are picking up 4 or more parcels. Row 1 shows the date the parcels are picked up and Row 2 shows the week day corresponding to the pick-up dates.
Our challenge is that customers do not always follow their pick-up dates for 4 or more parcels. We would like to track (Column Z) and reward our customers who complied with their pick-up dates for 4 or more parcels from June 14th to June 16th (Column G to Column S).
We have more than 10 customers so counting manually is very challenging. I have reviewed online tutorials on this but it seems that the COUNTIFS function only works if the variables tracked are found in columns. Our records are in rows.
Thanks for the help.
Help101
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]June 1[/TD]
[TD]June 2[/TD]
[TD]June 3[/TD]
[TD]June 4[/TD]
[TD]June 5[/TD]
[TD]June 6[/TD]
[TD]June 7[/TD]
[TD]June 8[/TD]
[TD]June 9[/TD]
[TD]June 10[/TD]
[TD]June 11[/TD]
[TD]June 12[/TD]
[TD]June 13[/TD]
[TD]June 14[/TD]
[TD]June 15[/TD]
[TD]June 16[/TD]
[TD]June 17[/TD]
[TD]June 18[/TD]
[TD]June 19[/TD]
[TD]June 20[/TD]
[TD]June 21[/TD]
[TD]June 22[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Customer[/TD]
[TD]Preferred Pick-up Day[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]Number of Time Customer Picked Up 4 or more Parcels on Preferred Pick-up Day[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Customer 1[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Customer 2[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Customer 3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Customer 4[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Customer 5[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Customer 6[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Customer 7[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Customer 8[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Customer 9[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Customer 10[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 660px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
We have a daily log of the number of parcels picked up by our customers. The number of parcels to be picked up ranges from 0 to a maximum of 5 per day.
Customers are each assigned a pick-up day (Column C) if they are picking up 4 or more parcels. Row 1 shows the date the parcels are picked up and Row 2 shows the week day corresponding to the pick-up dates.
Our challenge is that customers do not always follow their pick-up dates for 4 or more parcels. We would like to track (Column Z) and reward our customers who complied with their pick-up dates for 4 or more parcels from June 14th to June 16th (Column G to Column S).
We have more than 10 customers so counting manually is very challenging. I have reviewed online tutorials on this but it seems that the COUNTIFS function only works if the variables tracked are found in columns. Our records are in rows.
Thanks for the help.
Help101
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]June 1[/TD]
[TD]June 2[/TD]
[TD]June 3[/TD]
[TD]June 4[/TD]
[TD]June 5[/TD]
[TD]June 6[/TD]
[TD]June 7[/TD]
[TD]June 8[/TD]
[TD]June 9[/TD]
[TD]June 10[/TD]
[TD]June 11[/TD]
[TD]June 12[/TD]
[TD]June 13[/TD]
[TD]June 14[/TD]
[TD]June 15[/TD]
[TD]June 16[/TD]
[TD]June 17[/TD]
[TD]June 18[/TD]
[TD]June 19[/TD]
[TD]June 20[/TD]
[TD]June 21[/TD]
[TD]June 22[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Customer[/TD]
[TD]Preferred Pick-up Day[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]Number of Time Customer Picked Up 4 or more Parcels on Preferred Pick-up Day[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Customer 1[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Customer 2[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Customer 3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Customer 4[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Customer 5[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Customer 6[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Customer 7[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Customer 8[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Customer 9[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Customer 10[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 660px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]