Thread: average of 5
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrbob16 mrbob16 is offline
external usenet poster
 
Posts: 10
Default average of 5

I have a spreadsheet in cell b13 I start entering data till b59. I want to
take a running average of the last 5 cells that contain data. Not all cells
will have an entry and every 6th cell has a different formula. I also want to
move this running average to row c.
--
mrbob16