Multiple criteria
Hi community! i need your help, I need to get a number based if the formula find match with multiple criteria in different rows.
How can I get the result in the left side (yellow field) from the information on the right hand???
Thanks in advance!!!
Tags:
Answers
-
Hi Armando!
If you just want to know how many rows meet your criteria, you can use the COUNTIFS function.
https://help.smartsheet.com/function/countifs
If you want some other grouping (sum of result, etc.) you can use the COLLECT function in conjunction with another function (SUM, AVG, etc.)
-
Hi! thanks for the help, I'd like to get the data on the left side with the data on the righ hand that meets the two criteria from the left hand chart.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!