I got it.
I changed the AVERAGE array formula provided above to SUM and made a column to sum numerator. I did same for denominator. Then took the average across the row of those two cells. (note - I had to insert an intermediate formula where if denominator is blank, numerator would be blank, not zero).
Hope this helps anyone else.
|