Correct Formula to use? COUNTIFS

Good day,

I need to count the number cells that needs to comply to 2 types of criteria. I have a summary sheet that contains certain names, then on another sheet I have the 2 criteria's to be met - one matching the name as on summary sheet and the other criteria being the status on the other sheet.

For Example: On the Summary sheet I have: Apple

On the other sheet I have the same name: Apple,

On the other sheet I have a status: 1.

The formula I needs to be on summary sheet , referencing Apple, and then count on the other sheet how many statuses does Apple have of 1

Pls help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!