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


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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!