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!

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!

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!

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