AVERAGEIF formula

I'm trying to get the average of the # of weeks it takes from an NDA to LOI for a particular team (Koala). I am using the formula:

=AVERAGEIF([Business Unit]:[Business Unit], "Koala", [Weeks NDA to LOI]@row)


I'm stumped. Thanks for your help!

Best Answer

Answers