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

You're welcome, Jarod - thanks for feeding back.

Pete

"Jarod" wrote in message
...
I agree, it does need a redesign. Unfortunately, I'm in no position to
approve/undertake it. This formula is what I needed, I won't have
criteria
in the "subtotal" row, so it wouldn't count it anyways. Don't know why I
didn't see that.

Thanks!