stupid sum question

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,218,493
Messages
6,142,809
Members
450,447
Latest member
gtnz02

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
Back
Top