Count if multiple criteria with corresponding rows

[markdwalls]

Hi All,

Please see below. I need a formula (in yellow cells) that will return how many times the number is counted as well as the corresponding row returning a "yes". So for example, cell BA3 should be 6. Bit stuck with this one so any help will be appreciated.

Thanks in advance,

Mark

 

[Fluff]

Glad we could help & thanks for the feedback.