I am trying to use the AVERAGEIF function to give calculate averages based on dynamic data. The formula I want to work is:
but this returns the "#DIV/0!" error.Please Login or Register to view this content.
However,
returns the correct value.Please Login or Register to view this content.
I want to be able to calculate averages of only the cells that are greater than the value of cell D6. Is there a way to do this?
Thanks in advance.
-Andy
Bookmarks