automatically add totals

**kcrush** · 02-10-2012, 05:04 PM

I have a spreadsheet with two columns. A is a column with a series of dates, only showing weekdays. Column B contains numbers corresponding to the date it is next to in column A. I would Like to add a third column that is for Weekly Totals.

How can I make it so that when I type in the numbers next to each date, it will automatically add them and create a total for that week (5 weekdays) in column C. Essentially column C would only have a number every 5 rows showing the total.

Thank you!

**jeffreybrown** · 02-10-2012, 06:10 PM

How about something like this example...

I used column D as a helper column...

**kcrush** · 02-17-2012, 03:27 PM

Jeff,

Thank you for your response. I am not good with excel; I don't know how to incorporate what you did into my exisitng workbook. I was hoping there was a macro I could just paste in. Can you please explain what you did.

THANKS!

**jeffreybrown** · 02-17-2012, 06:16 PM

I used the WEEKNUM function in a helper column to return the week number, then used Sumif to Sum up the amount by week number. I'm sure somebody could offer a formula without the need to use a helper column, but sometimes using a helper column is not all that bad.

If this does not work for you then you should attach a sample workbook with what you have and what you desire. Macro's are fine, but if there is a native worksheet formula then ofter times this is the best and most efficient choice unless you workbook structure does not cooperate.