Multiple criteria

Armando RdzLC

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!!!

Hayley B

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.)

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

Armando RdzLC

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.