![]() |
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? |
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? |
All times are GMT +1. The time now is 04:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com