Hi All,
I want to count the total number of Pass and Fail based on Column 1 (Originating) site. For. Eg., If I select US, I should get 3 pass and 1 Fails, and if I select UK I should get 1 pass and 1 fails. Can someone please help?
<tbody>
</tbody>Desired Output
Selected Site (Based on Dropdown) - US
Pass: 3
Fail: 1
Any help will be appreciated.
Thanks,
RAC
I want to count the total number of Pass and Fail based on Column 1 (Originating) site. For. Eg., If I select US, I should get 3 pass and 1 Fails, and if I select UK I should get 1 pass and 1 fails. Can someone please help?
Originating Site | Description |
US | Pass |
US | Pass |
UK | Pass |
US | Fail |
US | Pass |
UK | Fail |
<tbody>
</tbody>
Selected Site (Based on Dropdown) - US
Pass: 3
Fail: 1
Any help will be appreciated.
Thanks,
RAC
Last edited: