I am trying to create a table summarizing by date and yes and no. I tried using Countif's formula but its not working.
The data i am using (detail is)
And the table or grid I am trying to populate is
If I am not using the right command please let me know. I am trying to Count how many yeses and no's per day for the data. thanks in advance for your help!
The data i am using (detail is)
| Sales Order | Purchase Date | On Shipping Report | Tracking in Magento | $ Value in Magento | Tracking 3PL | Tracking in 3PL |
| 600000025112 | 4/1/2021 | 137187211085 | Yes | 137187211085 | Yes | |
| 600000025113 | 4/1/2021 | 9405516901545008915906 | Yes | 9405516901545008915906 | Yes | |
| 500000024925 | 4/1/2021 | 9400116901545008915545 | Yes | 9400116901545008915545 | Yes | |
| 500000024926 | 4/1/2021 | 9400116901545008915576 | Yes | 9400116901545008915576 | Yes | |
| 500000024927 | 4/1/2021 | 9400116901545008915590 | Yes | 9400116901545008915590 | Yes | |
| 500000024928 | 4/1/2021 | 9400116901545008915521 | Yes | 9400116901545008915521 | Yes | |
| 500000024929 | 4/1/2021 | 9405516901545008915555 | Yes | 9405516901545008915555 | Yes | |
| 500000024930 | 4/1/2021 | 9400116901545008915569 | Yes | 9400116901545008915569 | Yes | |
| 500000024931 | 4/1/2021 | 9400116901545008914142 | Yes | 9400116901545008914142 | Yes | |
| 500000024932 | 4/1/2021 | 9400116901545008915583 | Yes | 9400116901545008915583 | Yes | |
| 500000024933 | 4/1/2021 | 9400116901545008915507 | Yes | 9400116901545008915507 | Yes | |
| 500000024934 | 4/1/2021 | 9400116901545008915736 | Yes | 9400116901545008915736 | Yes | |
| 600000025114 | 4/1/2021 | 9400116901545008912049 | Yes | 9400116901545008912049 | Yes | |
| 600000025115 | 4/1/2021 | 9400116901545008912032 | Yes | 9400116901545008912032 | Yes | |
| 600000025116 | 4/1/2021 | 9400116901545008912018 | Yes | 9400116901545008912018 | Yes | |
| 500000024935 | 4/1/2021 | 9405516901545008915715 | Yes | 9405516901545008915715 | Yes | |
| 600000025117 | 4/1/2021 | 137187211096 | Yes | 137187211096 | Yes | |
| 500000024936 | 4/1/2021 | 9400116901545008915743 | Yes | 9400116901545008915743 | Yes | |
| 600000025118 | 4/1/2021 | CJ461007706US | Yes | CJ461007706US | Yes | |
| 600000025119 | 4/1/2021 | 9400116901545008912230 | Yes | 9400116901545008912230 | Yes | |
| 600000025120 | 4/1/2021 | 9405516901545008912219 | Yes | 9405516901545008912219 | Yes | |
| 500000024937 | 4/1/2021 | 9405516901545008912028 | Yes | 9405516901545008912028 | Yes | |
| 600000025121 | 4/1/2021 | 9400116901545008912247 | Yes | 9400116901545008912247 | Yes | |
| 600000025123 | 4/1/2021 | 9405516901545008912271 | Yes | 9405516901545008912271 | Yes | |
| 500000024938 | 4/1/2021 | 9400116901545008912056 | Yes | 9400116901545008912056 | Yes | |
| 600000025124 | 4/1/2021 | 137187211188 | Yes | 137187211188 | Yes | |
| 500000024939 | 4/1/2021 | 9400116901545008912063 | Yes | 9400116901545008912063 | Yes | |
| 500000024940 | 4/1/2021 | 137187211133 | Yes | 137187211133 | Yes | |
| 600000025125 | 4/1/2021 | 9400116901545008912292 | Yes | 9400116901545008912292 | Yes | |
| 500000024941 | 4/1/2021 | 9400116901545008912087 | Yes | 9400116901545008912087 | Yes | |
| 600000025126 | 4/1/2021 | 9405516901545008912226 | Yes | 9405516901545008912226 | Yes | |
| 600000025127 | 4/1/2021 | 9400116901545008912254 | Yes | 9400116901545008912254 | Yes | |
And the table or grid I am trying to populate is
| Shipping update as of 5.12.21.xlsx | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Tracking in Magento | ||||
| 2 | Date | Yes | No | ||
Sheet5 | |||||
If I am not using the right command please let me know. I am trying to Count how many yeses and no's per day for the data. thanks in advance for your help!
