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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating weekly summaries
Why don't you add a column to your data which is the week number (using
WEEKNUM function). Then subtotal on that. Also, check into Pivot Tables. They are a much simpler and more powerful way of summarizing your data than the ...IF functions. Regards, Fred. "Jim" wrote in message ... 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 |
Reply |
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 |