View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarod Jarod is offline
external usenet poster
 
Posts: 22
Default Average If - averaging cells based on value of another cell

I have a spreadsheet where O:62 and O:63 are products of a formula in their
rows. The cells in between are segmented, so I can't do a simple O1:0:60,
it's more like O5:O9,O16:O21,etc

So, if C5:C60=C62, I need the average of O5:O9, O16:O21, O28:O33, O41:O45, &
O52:O57. I can't just do O5:O57 because in between the sections are other
averages.

Thanks in advance!