AVERAGEIF with multiple criteria



I am trying to find the Average calculated time of a column(Avg Time) when it is a specific Status and Px Code. For Example, The average time code '1234' is in status 'Approved.'

I've tried these two formulas:

=AVERAGEIF({Avg Time}, AND({Px}, Px@row, {Status}, Status@row))

=AVERAGEIF(AND({Px}, Px@row, {Status}, Status@row), {Avg Time})

both of which spit out a #INVALID DATA TYPE error..

Avg Time is a number with decimals (ie: 18.1, 153.25, 50.0)

Status is a drop down list of specific Statuses

Px is a drop down of specific codes

Any help is greatly appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!