Sum Rows until there is a new date in Column A.

[Bpd]

Please reference my attached spreadsheet. The formula I am Working on is in column D starting at row 7 under "Actual Paid Gross". Is there a formula that would sum the current row and all the rows below it until a Date was found in Column A?

For example reference D9. If the formula worked correctly it would sum from G9:N12. The formula would stop suming the rows below it once a new date is in row A. In this example the formual would stop at N12 because of the date in A13. Right now I can only get it to sum one row.

[NBVC]

Try:

=IF(A7<>"",SUM(G7:IF(A8="",INDEX($N8:$N$20,MATCH(TRUE,INDEX($A8:$A$20<>"",0),0)-1),N7)),"")

copied down

[Bpd]

This works great thanks