Subtotaling based on date in a column

[kylewent]

I am trying to create a subtotal in Column L for the values in Column K that all have the same date in Column A. All of the Dates in Column A are in chronological order. No dates are out of order.

Example
A1 = 11/2/2008 : K1 = 22.00
A2 = 11/2/2008 : K2 = 25.00
A3 = 11/4/2008 : K3 = 12.50
A4 = 11/4/2008 : K4 = 13.22
A5 = 11/4/2008 : K5 = 11.65

L1 should = 47.00
L3 should = 37.37

What formula would I put in L1 to perform this task?

Thanks is advance for the assistance.

Kyle <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[Jon von der Heyden]

Hello Kyle, and welcome to MrExcel.com

Try:
=SUMIF(A:A,A1,K:K)

 

[kylewent]

That was fabulous. Thanks for the quick reply. Great pic too. Congratulations on the baby.

Kyle Wentworth

 

[Jon von der Heyden]

Thanks Kyle. I must update the pic, she's 3 months already.

Stick around, this is a cool board. Lots too learn.