View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gilbert DE CEULAER Gilbert DE CEULAER is offline
external usenet poster
 
Posts: 25
Default Average of the last x entries with conditions

I am looking for a formula that calculates :
- the average of the last x entries in a row - that are NOT formulas, and
that are greater than 0 -
and
- where the header of that row is equal to "xyz".
Thanks,
Gilbert