How do I approach this?


New Member
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 –


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.

Some videos you may like

This Week's Hot Topics