Count of Multiple options selected

[Ashtong]

Hi,

I currently have a spreadsheet survey sent to multiple respondents, where they fill it up accordingly.

Certain sections have questions like "Please select the brand of car(s) that you own". Beside each brand will be an activeX tickbox which links the value TRUE to my consolidator sheet.

I would like to know the best method if i want to count how many people own a "Toyota" and a Honda. And if possible to bring in more depth and also count how many people own a "Merc and a Toyota", a "Honda and a Merc" etc etc


Thanks for your help

 

[venkat1926]

use SUMPRODUCT function