Correct Formula to use? COUNTIFS
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
Help Article Resources
Check out the Formula Handbook template!