<tbody>
A1
B1
C1
D1
Order No:
BOX or WRAP
Medium
Large
MK23
1
1
0
MK23
1
0
1
MK23
1
1
0
MK24
1
1
0
MK24
1
0
1
</tbody>
B1, have sorted to 1 for BOX and 0 for Wrap
I would like to count, how many medium and how many large boxes for each Order No:
The output should be as below...