Average Formula

alondra1329

Hello,

I am trying to find the average number of days a person works on a specific type of file. In example:

What is the average number of days it took Tom to complete type “A” files from the Intake Date to the RFA date?

What is the average number of days it took Tom to complete type “B-Renewal” files from the Intake Date to the RFA date?

I was planning on using this information on a sheet summary or chart if possible. I tried using the AverageIF formula but did not know how to include multiple criteria (type of file and name of Investigator). 

Paul Newcome

You would need an AVG/COLLECT combo to have multiple range/criteria sets.

=AVG(COLLECT({Range To Average}, {range 1}, criteria 1, {range 2}, criteria 2))

Paul Newcome

You would need an AVG/COLLECT combo to have multiple range/criteria sets.

=AVG(COLLECT({Range To Average}, {range 1}, criteria 1, {range 2}, criteria 2))

alondra1329

Thank you so much, this worked!

Paul Newcome

Happy to help. 👍️