| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I sort a spreadsheet of daily events into weekly totals?
I have a worksheet containing figures reported on a workdate daily basis; I
wish to split it into totals by a weekly basis; can I create a formula to sort the data in weekly totals? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I sort a spreadsheet of daily events into weekly totals?
Hi Polly,
You can probably use the WEEKNUM function, but you will have to install the Analysys Toolpack if you haven't already done so. Then you can use SUMIF and WEEKNUM to sum all results from any given week. Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Daily Info to Weekly | Excel Discussion (Misc queries) | |||
| Can I use VBA to automate the recording of daily events? | Excel Discussion (Misc queries) | |||
| Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
| Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
| How can I calculate weekly totals of daily data in Excel | Excel Worksheet Functions | |||
Hybrid Mode
