I have a spreadsheet that is 4,000 rows. I have identified all matching rows (match identifier is in column H), each matching group is separated by a blank line. I need to get a sum of column E in each matching group to return in column I only once.
E F G H I
1 -25.45 2/2/2007 2/2/2007 39115 =sum(E1:E4)
2 6,590.10 2/2/2007 2/2/2007 39115
3 45.10 2/2/2007 2/2/2007 39115
4 4101.50 2/2/2007 2/2/2007 39115
(BLANK LINE)
6 25.00 2/2/2007 2/2/2007 45132 =sum(E6:E7)
7 150.25 2/2/2007 2/2/2007 45132
(BLANK LINE)
9 75.00 2/2/2007 2/2/2007 1279 =sum(E9)
(BLANK LINE)
11 125.75 2/2/2007 2/2/2007 8450 =sum(E11:E12)
12 95.00 2/2/2007 2/2/2007 8450