Copying daily data from one tab to a weekly summary table
in [Functions]
|
Prev: entering more than seven levels of functions with in a function
Next: How can I insert a date which is the first date of the following m
From: Dam on 3 Jun 2010 01:01 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!
From: Jacob Skaria on 3 Jun 2010 01:01 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! > >
From: Jacob Skaria on 3 Jun 2010 01:22 Please elaborate with an example...and mention how your workbook is structured and how the sheets are named.. -- Jacob (MVP - Excel) "Dam" wrote: > 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! > > > > > >
From: Dam on 3 Jun 2010 01:22 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! > > > >
From: Roger Govier on 3 Jun 2010 01:44
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" <Dam(a)discussions.microsoft.com> wrote in message news:F029F00E-498B-46E2-B878-610A060955DF(a)microsoft.com... > 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 |