Thread: how do I average only certain cells based on month?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jcannon1[_2_] jcannon1[_2_] is offline
external usenet poster
  
Posts: 1
Default how do I average only certain cells based on month?
I am creating a spreadsheet that tracks our monthly goals for sales. My
spreadsheet looks like so:

Jan Feb Mar ETC
5000 5000 5000

I also have a portion for a YTD Average - I want the YTD average column to
pull the average based on the current month - ie if its February I want it to
add Jan + Feb / 2.... if its March I want it to add Jan + Feb + Mar / 3....

Can anybody help me on this?
Reply With QuoteReply With Quote