AVERAGEIF with multiple criteria

Dakota Haeffner

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!

Paul Newcome

You are going to need an AVG/COLLECT combo.

=AVG(COLLECT({range to average}, {1st criteria range}, 1st criteria, {2nd criteria range}, 2nd criteria))

Paul Newcome

You are going to need an AVG/COLLECT combo.

=AVG(COLLECT({range to average}, {1st criteria range}, 1st criteria, {2nd criteria range}, 2nd criteria))