AVERAGEIF with multiple criteria
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!
Best Answer
-
You are going to need an AVG/COLLECT combo.
=AVG(COLLECT({range to average}, {1st criteria range}, 1st criteria, {2nd criteria range}, 2nd criteria))
Answers
-
You are going to need an AVG/COLLECT combo.
=AVG(COLLECT({range to average}, {1st criteria range}, 1st criteria, {2nd criteria range}, 2nd criteria))
Help Article Resources
Categories
Check out the Formula Handbook template!