COUNT by Manager and by Product

Amanda Chu

I have a column called "Manager" and Product columns called Product1, Product2, Product3, etc and these are all checkboxes

How can I do a count by Manager of Product? 

Example: 

Joe Smith

• Product1 - 3
• Product2 - 10

Jennifer Johnson

• Product2 - 12
• Product3 - 5
• Product5 - 10

Paul Newcome

Are the products children rows of the managers?

Andrée Starå

Hi Amanda,

Try this.

=COUNTIFS(Manager:Manager; "Joe Smith"; [Product1]:[Product1]; "1")    

The same version but with the below changes for your and others convenience.  

=COUNTIFS(Manager:Manager, "Joe Smith", [Product1]:[Product1], "1")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Amanda Chu

No, the Manager and Product columns are on the same row

Paul Newcome

My apologies. I meant to ask...

 

Are the products children rows in your summary sheet? Is your original post the desired layout for the summary data?