Formula help needed please

[Bob Newman]

Excel 2010. I have a database containing one line for each date and several columns corresponding to that date. I am trying to create a table that shows the totals in each column for each WEEK of 2013. ie the totals for Jan. 1 through January 7 and so on. I know the sumif formula but am not surehow to total it on a weekly basis. Any help would be appreciated.

Thanks in advance... Bob

 

[isabelle]

hi Bob,

the Pivot Table would be appropriate for this problem

http://www.cpearson.com/excel/pivots.htm

http://www.addictivetips.com/windows-tips/office-excel-2010-tutorial-pivot-tables/

isabelle


Le 2012-12-27 12:10, Bob Newman a écrit :

Excel 2010. I have a database containing one line for each date and several columns corresponding to that date.

I am trying to create a table that shows the totals in each column for
each WEEK of 2013. ie the totals for Jan.

1 through January 7 and so on. I know the sumif formula but am not
sure how to total it on a weekly basis. Any help would be appreciated.

 

[Bob Newman]

hi Bob,



the Pivot Table would be appropriate for this problem



http://www.cpearson.com/excel/pivots.htm



http://www.addictivetips.com/windows-tips/office-excel-2010-tutorial-pivot-tables/



isabelle





Le 2012-12-27 12:10, Bob Newman a écrit :




I am trying to create a table that shows the totals in each column for

each WEEK of 2013. ie the totals for Jan.



1 through January 7 and so on. I know the sumif formula but am not

sure how to total it on a weekly basis. Any help would be appreciated.

Thanks Isebelle... Bob