COUNT by Manager and by Product

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

Jennifer Johnson

Find more posts tagged with

Healthcare

Formulas

Are the products children rows of the managers?

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

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

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?

Writing Formula for Sheet Summary Field
Based on the screenshot below, I am trying to write a formula that will pull in the reason for change on the row where " most recent change" is checked. Thoughts on the best formula? I've tried: =IF([Most Recent Change]:[Most Recent Change] = 1, [Reason for Change]:[Reason for Change] , "") Is there something I can do with…
Help with this Formula
I'm trying to seta formula for the health of the project's tasks based on certain conditions. This is the formula: =IF(OR(AND(Status@row <> "Complete", [End Date]@row < TODAY()), AND(Status@row = "In Progress", VALUE([% Complete]@row ) < 0.3, NETDAYS(TODAY(), [End Date]@row ) <= 30), AND(Status@row = "Not Started", [Start…
Break Up Multi-Entry Row
I'm using a form entry (into an Intake Sheet) in which someone can select multiple locations for the same Initiative. I'm looking to copy the row to a different Master sheet, but would like to have the same row copied multiple times, once per location selected. Intake Sheet: Desired Result in Master Sheet: Basically, I…