Need help to sum live data in 2 week increments.

idoon3y

New Member
Joined
Apr 27, 2020
Messages
8
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Web
My goal is to understand which two week increments of a marketing campaign were most/least effective.

Column A: live data for a marketing campaign (leads generated)

Column B: Sum up the live data up until 2 weeks after the start date of the campaign. After the 2 weeks is complete, I would like this data to “stay” in the cell and not disappear after the 2 weeks is over.

Column C: Sum up the live data from weeks 3-4 of the campaign. After the 4th week is complete, I would like this data to “stay” in the cell and not disappear after the two week span of weeks 3-4 is over.

Column D: Sum up the live data from weeks 5-6 of the campaign. After the 4th week is complete, I would like this data to “stay” in the cell and not disappear after the two week span of weeks 5-6 is over.

I would like this to continue until weeks 15-16 of the campaign.

I have tried the following formula, but this makes it so the values disappear after the 2 week period is over.

- Where B4 is the date 2 weeks after the start date and A7 is the live data I want to input

=IF(TODAY()<=$B$4,SUM(A7))

Does anyone know of any ways to make this possible or easier?

I would really appreciate any help!
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,213,484
Messages
6,113,923
Members
448,533
Latest member
thietbibeboiwasaco

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