If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Copying daily data from one tab to a weekly summary table
WEEKNUM do not work with arrays. You can use a helper column to get the
weeknum for each row and then use that column in your formula. -- Jacob (MVP - Excel) "Dam" wrote: 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! |
#3
|
|||
|
|||
Copying daily data from one tab to a weekly summary table
I am still lost then, Im taking information which i need weekly based on
sunday through satruday and getting that totaled. Lets use this as an example: 7days of information from 7 seperate columns, needs to be in those identical columbs on the next tab, just in week totals instead of daily totals. If I am not to use an array which I wasn't aware I was doing, how do I fix this issue. "Jacob Skaria" wrote: WEEKNUM do not work with arrays. You can use a helper column to get the weeknum for each row and then use that column in your formula. -- Jacob (MVP - Excel) "Dam" wrote: 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! |
#4
|
|||
|
|||
Copying daily data from one tab to a weekly summary table
Hi
Supposing your weeknum is in column H on Sheet1 With Weeknumin A2 of Sheet2 running down the page, enter in B2 =SUMIF(Sheet1!$H:$H,$A2,Sheeet1!A:A) Copy across through columns C:H Copy down the page as far as required -- Regards Roger Govier "Dam" wrote in message ... I am still lost then, Im taking information which i need weekly based on sunday through satruday and getting that totaled. Lets use this as an example: 7days of information from 7 seperate columns, needs to be in those identical columbs on the next tab, just in week totals instead of daily totals. If I am not to use an array which I wasn't aware I was doing, how do I fix this issue. "Jacob Skaria" wrote: WEEKNUM do not work with arrays. You can use a helper column to get the weeknum for each row and then use that column in your formula. -- Jacob (MVP - Excel) "Dam" wrote: 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! __________ Information from ESET Smart Security, version of virus signature database 5167 (20100602) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5167 (20100602) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Thread Tools | |
Display Modes | |
|
|