| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating weekly summaries
I have a workbook with 4 sheets used to track sales. On sheet 1 we enter the
sales information. Sheet 2 is used to summarize the sales daily, sheet 3 for weekly and sheet 4 monthly. Daily summaries are pretty simple. I can use SUMIF and COUNTIF to count the number of sales for the day, and total them up. The weekly summaries seem to be a little more tricky for me. I can use column A for the first day of the week and column B for the last day of the week, but I could use a little help with the formulas to count and total the sales for the week. Anyone have any thoughts? Thanks Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a weekly rotating employee work schedule | Excel Discussion (Misc queries) | |||
| Creating Bi-Weekly Time Sheet to Calculate Hours Worked | Excel Discussion (Misc queries) | |||
| Summaries | Excel Worksheet Functions | |||
| with weekly score sheet how do I column a weekly progressive aver. | Excel Worksheet Functions | |||
| Pivot Table Summaries | Excel Worksheet Functions | |||
Threaded Mode
