weekly sum

  1. A

    Summing weekly data for a specific month

    Hi all, I am receiving weekly data which I try to convert to a monthly one. My challenge is to identify cells related to, for example March and sum those in one cell related to March. I know the dates when data is reported ahead of time (e.g. every Friday). Since dataset will expand in future...
    • Adar
    • Thread
    • monthly data from weekly summing weekly sum
    • Replies: 1
    • Forum: Excel Questions
  2. B

    Ad an amount weekly

    Hi I am trying to add a rent amount to a total on a weekly basis. I have a dashboard that is used by the boss and he wants to have it updated weekly. Is there a formula that can automatically reference an amount cell and add that amount to the total on a weekly basis. Say every Monday. Thank you...
  3. A

    How to add weekly values from Monday to Sunday

    <colgroup><col span="2"><col></colgroup><tbody> The required results from the below data are: Required Result Week 25 = Batches 25 Week 26 = Batches 40 Data <colgroup><col><col><col></colgroup><tbody> Data - Day No. of Batches 16/06/14 Mon 5 17/06/14 Tue 6 18/06/14 Wed 9...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top