ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add numbers in a range of data from days of the week? (https://www.excelbanter.com/excel-worksheet-functions/225745-how-do-i-add-numbers-range-data-days-week.html)

Peggy

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?

Jacob Skaria

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