View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steph44haf steph44haf is offline
external usenet poster
 
Posts: 37
Default Summing Weekly Totals into Monthly Totals

06/01/06 06/08/06 06/15/06 06/22/06 06/29/06
fish 10 12 11 14 12
meat 40 45 41 41 43
eggs 50 50 51 52 53
fruit 1 2 1 3 2
veggies 90 91 92 89 89

I need a way to summarize this weekly data into montly data. For example
June Fish totals would be 59. I am going to have 3-4 yrs of weekly data that
I need to show by month. I know I can chart it, but I want it in data sheet
format not charts.