How to use COUNTIFS with multiple criteria?


Hello All,

What would a formula look like if I need to count the following from another sheet:

Data I am trying to capture: Number of Catalogs and Design Guides Completed in 2022

Columns I need to reference:

Project Type (column 1)

  1. Catalog
  2. Design Guide

Status (column 2)

  1. Completed

End Date (column 3)

  1. 2022

I hope this is clear, but feel free to ask for me clarity!


Ryan H

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!