LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dam dam is offline
external usenet poster
 
Posts: 5
Default Copying daily data from one tab to a weekly summary table

I have been working on this for a little while now and can't seem to grasp
the right formula to use. I have columns of data sorted by name to be
tracked daily. I need to then give my boss the information so she can not
only see it daily and monthy which I have figured out - but wants to see
weekly as well and thats where im stumped.

The formula I am using to get the week number populated works great and is
=WEEKNUM(Table1[[#This Row],[Ddate]])

What I need to do is get totals from "Table2" to "Table3" into a weekly
format instead of daily. So in essence everything that says week 1 next to
it - totaled onto table3 in tab 2.

Any input on this delema would be greatly appreciated!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting daily data into weekly, monthly and yearly data CEGavinMcGrath Excel Discussion (Misc queries) 4 April 3rd 23 06:54 PM
Converting daily data into weekly Robin Excel Discussion (Misc queries) 1 October 7th 08 04:29 AM
Collecting weekly and monthly totals from daily data Kasper Excel Worksheet Functions 0 January 12th 06 08:02 PM
How can I calculate weekly totals of daily data in Excel BarrySandell Excel Worksheet Functions 4 October 8th 05 04:28 AM
Daily data to weekly data conversion in Excel? dlanc Excel Worksheet Functions 1 August 9th 05 02:12 AM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"