I've been working with several formulas to get an average of certain rows, based on values in a column, but I'm getting #DIV/0 errors.
The average range depends on a number in another column, and it must only average positive numbers.
I've attached a spreadsheet with a note showing what I'd like.
It seems like a simple formula, but I'm just not experienced enough to get it to work. If it helps I can post the formula I've been trying.
Thanks to all you bright people helping me!
Bookmarks