Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add numbers in a range of data from days of the week?
I am trying to add income from the days of one work week together. I then
want to build my spreadsheet so I can look at different weeks in a month. I thought I would build in a button to give me this option to either view the information daily or weekly. The hardest bit is trying to build a formula that's cleaver enough to give me this weekly information? Also when two months merge together for example March 30th - 5th April. Any thoughts of where I begin? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add numbers in a range of data from days of the week?
You can achieve this by formulas itself. Just to start please share with us
what data you already have..Is that columns like date,income If this post helps click Yes --------------- Jacob Skaria "Peggy" wrote: I am trying to add income from the days of one work week together. I then want to build my spreadsheet so I can look at different weeks in a month. I thought I would build in a button to give me this option to either view the information daily or weekly. The hardest bit is trying to build a formula that's cleaver enough to give me this weekly information? Also when two months merge together for example March 30th - 5th April. Any thoughts of where I begin? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
5 working days of a week | Excel Discussion (Misc queries) | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
how to chart data spread over 24 hours a day and 7 days a week? | Charts and Charting in Excel | |||
7 days of the week | Excel Discussion (Misc queries) | |||
Days of the week. | Excel Worksheet Functions |