# Correct Formula to use? COUNTIFS

Options

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

• ✭✭✭✭✭✭
Options

Hi Aubrey, assuming that Apple is in a column called Fruit in both sheets, create this formula in your summary sheet:

=COUNTIFS({Fruit}, Fruit@row, {Status}, 1)

Here’s the help sheet on how to use the function:

https://help.smartsheet.com/function/countifs

• ✭✭✭✭✭✭
Options

Hi Aubrey, assuming that Apple is in a column called Fruit in both sheets, create this formula in your summary sheet:

=COUNTIFS({Fruit}, Fruit@row, {Status}, 1)

Here’s the help sheet on how to use the function:

https://help.smartsheet.com/function/countifs

• Options

Thank you - appreciate the help

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!