Sum Checked Boxes referencing another sheet
Hello, I would like to get a formula that sums checked boxes only and also give me the count based on project status.
This "Metric Sheet" refers to a regular sheet assigned by team member.
Answers

Hey @Estefania Reyes
If I understand correctly, you are looking to get the total count of rows that (a) are assigned to the owner at row and have a check box and have a project status of "Complete". Is this accurate? In the formula below, each range is a single column in your source sheet (not the metric sheet). (The formula below is for the Complete project. In the other columns in your metric sheet, swap out Complete for the other respective Status choices)
=COUNTIFS({source sheet Owner column}, Owner@row, {source sheet Is this a Project? column}, 1, {source sheet Status column}, "Complete")
Remember you will have to insert each cross sheet reference into your sheet through the formula wizard.
Is this what you are looking for?
Kelly
Help Article Resources
Categories
Check out the Formula Handbook template!