Need to add x's in rows based upon letters in colums

[Giorgio5120]

Hi,

This is my first post in this forum. I have attached a xlsx that has client information. This is sort of a research piece for clients. For most values (in the MI-100 Form Tab) you will use x's to fill in what applies to that particular person (except for the Markets section which will use numbers). I need to add the rows into the "MI-100 Summary" Tab but this will be based upon ROW 1's Sources A-F.

So basically I need to add all the x's of row 3 that have selected A, All the x's of row 3 that have selected B, etc
All the x's of row 4 that have selected A, all the x's of row 4 that have selected B, etc.

Thanks so much for your help.

[CheshireCat]

For results corresponding to "X" entries, in cell C3 of the summary tab, paste:

Please Login or Register  to view this content.

Copy/autofill across & down.

You have not specified what you want done with the market results.