Data categorised formula

[samarbac]

Hi gurus,

I wonder if someone could help with the attached spreadsheet to count data and categorised in A & B section - so anytime if answer is Yes in any of the section if it's part of A or B than it count + add it in that section and work out total As & Bs

Hope you can help me with that.

Many thanks

[WideBoyDixon]

M6 formula:

=SUMPRODUCT(($B6:$I6="Yes")*($B$3:$I$3="A"))

O6 formula:

=SUMPRODUCT(($B6:$I6="Yes")*($B$3:$I$3="B"))

Copy down as necessary.

WBD

[samarbac]

Thanks WBD

how can I count of total As and Bs in specific sections ?

[WideBoyDixon]

Can you re-post the original sheet with some sample data and expected result?

WBD