Insert blank row and issue a sum

  • Thread starter Thread starter Walter Haddock
  • Start date Start date
W

Walter Haddock

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Formula 4
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
Multiple SUM's in a column 15
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
Insert blanks, but populate new blank rows in one column 6
Sum every Nth Row (almost working) 1
Need to sum row 7 columns based row 8 columns that are not Blank 3
sum of multiple rows 2

Back
Top