Formula to count cells in a column if box is checked
I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box.
In other words, there are two columns to include in the count from my Communication Tracker sheet:
Done -- checkbox column
and
Department -- dropdown column with options: Sales, Editorial, Education
I'd like a separate sheet to run a count for how many cells contain "Sales" ONLY IF the Done column is checked off.
Previously, I had done this without the added Done column and my formula was:
=COUNTIF({Communication Tracker Range 1}, "Sales")
Can't figure out how to write a formula that would capture all of this.
Thanks
Comments
-
=COUNTIFS({Communication Tracker Range 1}, "Sales", {Done Column Name}, 1)
Help Article Resources
Categories
Check out the Formula Handbook template!