View Single Post
  #10   Report Post  
puck1263 puck1263 is offline
Junior Member
 
Posts: 20
Default

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.