Correct Formula to use? COUNTIFS

Aubrey Ferreira

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

Lucas Rayala

https://community.smartsheet.com/discussion/116329/correct-formula-to-use-countifs

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

Lucas Rayala

https://community.smartsheet.com/discussion/116329/correct-formula-to-use-countifs

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

Aubrey Ferreira

Thank you - appreciate the help