tags:

views:

7

answers:

0

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