Whenever i add a new row the cell reference goes down, for example:
In this formula:
=AVERAGEIF($O$10:O576;">0";$O$10:$O$576)
after adding a new row it becomes
=AVERAGEIF($O$11:O576;">0";$O$11:$O$576)
and so on,
How to keep formula cell reference constant?
Bookmarks