AVERAGEIF with multiple criteria

Options

Hello,

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!