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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!