stupid sum question

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

jwinstonc

New Member
Joined
Jan 21, 2005
Messages
9
i want to add groupings of 7. I have individual sales data for each day and want to add each week up indvidually. so I am trying to have a column of weekly sales next to my daily sales. How do I accomplish this?
 

Scott R

Active Member
Joined
Feb 20, 2002
Messages
430
jwinstonc said:
i want to add groupings of 7. I have individual sales data for each day and want to add each week up indvidually. so I am trying to have a column of weekly sales next to my daily sales. How do I accomplish this?

One way is to use WEEKNUM function to group the data for use by the SUMIF function.
Book1
ABCDEF
4DailyWeekly
5DateWeekNumSalesWeekNumSales
612/5/2004501050102
712/6/2004501351113
812/7/200450195283
912/8/20045018
1012/9/20045012
1112/10/20045011
1212/11/20045019
1312/12/20045120
1412/13/20045115
1512/14/20045118
1612/15/20045119
1712/16/20045116
1812/17/20045112
1912/18/20045113
2012/19/20045212
2112/20/20045212
2212/21/20045217
2312/22/20045215
2412/23/20045211
2512/24/20045216
Sheet3
 

Watch MrExcel Video

Forum statistics

Threads
1,129,806
Messages
5,638,472
Members
417,026
Latest member
UDK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top