# Cumulative Total (Before, During, After)

#### Datatellsall2

##### New Member
Hello,

I'm trying to calculate the cumulative sum of time value (before, during, and after day of call) - see the last 3 columns. I've filled in the correct amounts below as a reference for the last 3 columns. What would be the best formula to calculate this? Essentially, my formula needs to look at any information prior to the day of call ("yes" or "no"), as well as post "yes". Please note that I must take into consideration the Unique Identifier, as I have roughly 400 different ones in my full data set.

 Unique Identifier Date Time Value Day of Call? Cumulative Sum of Time Value (Before Call) Cumulative Sum of Time Value (Day of Call) Cumulative Sum of Time Value (After Call) 100 8/1/2018 3 No 3 0 0 100 8/2/2018 3 No 6 0 0 100 8/3/2018 3 No 9 0 0 100 8/4/2018 2 Yes 0 2 0 100 8/5/2018 4 No 0 0 4 100 8/6/2018 6 No 0 0 10

<tbody>
</tbody>

M

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Replies
3
Views
231
Replies
0
Views
89
Replies
0
Views
19
Replies
3
Views
255
Replies
10
Views
329

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,255
Messages
5,769,061
Members
425,515
Latest member
baltusf

### 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.

### Which adblocker are you using?

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

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