How do I approach this?

[nwilliams92]

Hi all,

I’m having some difficulties as to how I should approach this issue. I’m confident with VLOOKUP, COUNTIF etc but just don’t know what combination to use to solve this problem.

Please see the table in the link below first –

[FONT=&quot]https://imgur.com/orj2UIh[/FONT]

I want to be able to calculate the number of ‘Yes’ values that appear in column B that relate to the region in column K. I want have a live update of the completions (yes/no) by each of the regions. Hence, when a 'Yes' is selected in Column B for the East Region the cell O2 will populate with a '1'

Thanks a lot.

 

[nwilliams92]

https://imgur.com/orj2UIh

Sorry there's the link.

 

[Michael M]

How about a Pivot Table using count for the Yes / No
Otherwise, try looking at SUMPRODUCT

 

[Michael M]

If you post some sample data, we may have a look at it.
Here's how

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[nwilliams92]

How about a Pivot Table using count for the Yes / No
Otherwise, try looking at SUMPRODUCT

Thanks for the response.

I would ideally not want to use a Pivot Table but will have a look at SUMPRODUCT.

 

[Fluff]

How about a countifs
=COUNTIFS(B:B,"Yes",K:K,O$3)