Accumulative Addition Formula

Hello,

Im currently working with large sets of data (Example attached) where I need to run an accumulated sum by day. I have dine this by doing a sum (fixing the first cell then dragging down then manually changing the starting point as the date changes. Is there a way of simplifying this?

All help would be appreciated.

Kind regards,

OMAccumulative Addition Help.xlsx

Cell C2 formula , Drag down

Formula:

Please Login or Register  to view this content.

Thats amazing, thank you.

Would it be able to put a % in column E to show what % of column B contributes to each day? (example 00:08:00 = 0.12% for the day)

If you are only interested in the cumulative sum for each day, then presumably you would like to see this only once. The following formula would show the total against the first occurrence of each date:

=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"")

Put it in C2 and copy down by double-clicking the fill handle (the small black square in the bottom right corner of the cursor). If you want to see the total only against the final entry for each date, then you could use this variation in C2 and copy down:

=IF(COUNTIF(A$2:A2,A2)=COUNTIF(A:A,A2),SUMIF(A:A,A2,B:B),"")

Hope this helps.

Pete

Cell E2 formula , Drag down

Formula:

Please Login or Register  to view this content.

Thanks Again.

Thats perfect

Sorry, thats accumulative %, for example E17 would be 10.6%?

Hi omlette_boy I don't understand your true demand for patterns. Can column E provide the desired result ?

Hi,

Apologies, column E is a cumulative % total E17= 100 %

I require each line to be the proportion of the total that day E.G E2 = 0.12% E3 = 0.00% E4 = 13.85%

Hope this helps.

Thank you for helping.

Kind regards,

OM

Think I've done that.

Thank you.

OM

Try this in E2 and copy down.

Please Login or Register  to view this content.

Thank you. That works perfectly.

Very much appreciated.

Thanks again

OM

You are welcome.