AVERAGEIF keeps returning "#Invalid Value"
I am creating Sheet Summary fields which count and average various values based on criteria.
In one cell, a formula that works is =COUNTIFS(Manager:Manager, HAS(@cell, "Tony"), [Complete Tasks]:[Complete Tasks], "1") / ([Last Week Helper Column]1 + 1)
For the record, Manager is a Contacts Column.
However, when I try a similar equation to calculate Average Duration based on the value of the Manager, I keep getting #Invalid Value. Both of the below equations do NOT work.
=AVERAGEIF(Manager:Manager, HAS(@cell, "Tony"), [Duration Cheat]:[Duration Cheat])
=AVERAGEIF(Manager:Manager, "Tony", [Duration Cheat]:[Duration Cheat])
I have verified that Duration Cheat is displaying a numerical value, and can add and sum when not using the AVERAGEIF function.
What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!