How to SUM fast based on dates?

[Jyggalag]

Hi all,

I currently have the following setup:

Is there an easy way to SUM this for each date?

I realize that I can do something like this:

However, I would like to make a solution in column C if possible or something along these lines, as the above solution would require me to make a new "Date" column as well.

Hope it makes sense?

Thanks!

Kind regards,
Jyggalag
Daedric Prince of Order anno March 26, 2007

 

[Legacy 143009]

Maybe a shorter solution is available. My solution would be:

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

 

[Jyggalag]

Maybe a shorter solution is available. My solution would be:

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

This is genius! Thank you so much Flashbond! Exactly what I was looking for

 

[Legacy 143009]

Glad it did help!