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:54
Tabs listed as daily totals - weekly totals - monthly totals

Table inside daily totals is sorted into columns which are as follows

Date Week "text a" "text b" "text c"
01/03/10 2 32 24 45
01/04/10 2 47 55 37

And so on - What I need is everything from "text a" that corresponds with
Week "2" (or for each individual week) to be totaled onto the second tab
labled Weekly Totals. A nudge in the right direction is what I am looking
for at this point because I have exhausted all I know to do. Even went
through the different sumif functions and possible different ways they could
be labled but am still running into snags.

"Jacob Skaria" wrote:

> 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: Jacob Skaria on 3 Jun 2010 01:54
Try this example which will take you inthe right direction...

With data arrange as below

ColA ColB ColC ColD ColE
Date Week text a text b text c
1/3/2010 2 32 24 45
1/4/2010 2 47 55 37
1/5/2010 3 32 24 45
1/6/2010 3 47 55 37


the below formula will give you the total of figures matching the weeknum
and the text in Row1.

=SUMPRODUCT((B2:B10=2)*(C1:E1="Text a")*C2:E10)

--
Jacob (MVP - Excel)


"Dam" wrote:

> Tabs listed as daily totals - weekly totals - monthly totals
>
> Table inside daily totals is sorted into columns which are as follows
>
> Date Week "text a" "text b" "text c"
> 01/03/10 2 32 24 45
> 01/04/10 2 47 55 37
>
> And so on - What I need is everything from "text a" that corresponds with
> Week "2" (or for each individual week) to be totaled onto the second tab
> labled Weekly Totals. A nudge in the right direction is what I am looking
> for at this point because I have exhausted all I know to do. Even went
> through the different sumif functions and possible different ways they could
> be labled but am still running into snags.
>
> "Jacob Skaria" wrote:
>
> > 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!
> > > > >
> > > > >
First  |  Prev  | 
Pages: 1 2
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