Insert blank row and issue a sum
 

The spreadsheet with about 10,000 rows that contains payroll information for
about 200 employees. Column G is the employee ID. When this number changes I
need a blank row inserted, column K need to be a sum of column E from last
blank row to the row prior to the row just inserted. Column L need to be a
sum of column F from last blank row to the current just inserted.
Is there a way to do this?

TIA
Walter

This will always sum the range from A1 to the location of the sum formula - 1
row.
=SUM(OFFSET(A1,0,0,ROW()-1,0))

Lance



"Walter Haddock" wrote:

The spreadsheet with about 10,000 rows that contains payroll information for
about 200 employees. Column G is the employee ID. When this number changes I
need a blank row inserted, column K need to be a sum of column E from last
blank row to the row prior to the row just inserted. Column L need to be a
sum of column F from last blank row to the current just inserted.
Is there a way to do this?

TIA
Walter

You may be able to get most of the way there pretty quickly by using
Data-Subtotals...
Look in the Help file for Insert Subtotals. You'll end up with the new
Subtotals in columns E & F, so you'll need to move them over into K and L


"Walter Haddock" wrote:

The spreadsheet with about 10,000 rows that contains payroll information for
about 200 employees. Column G is the employee ID. When this number changes I
need a blank row inserted, column K need to be a sum of column E from last
blank row to the row prior to the row just inserted. Column L need to be a
sum of column F from last blank row to the current just inserted.
Is there a way to do this?

TIA
Walter