AVERAGEIF formula

Deb White

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!

Mark Cronk

Hi @Deb White ,

Try:

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

Mark

Mark Cronk

Hi @Deb White ,

Try:

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

Mark

Deb White

Mark - this worked - thank you!

Mark Cronk

Happy to help. Thank you for using the Community.

Be Well, Mark