Sum Column below until...

[asfau]

I am trying to use a forumula that can sum a column until a certain point, which is when a non adjacent column's information is filled in. And then I want it to repeat.

For example:

Cells A1: has text, Cells E1-1000 has numbers
Cells A2-8: has blanks
Cells A9: has text
And perhaps Cells A:10-39: has blanks
And Cell A40: has text

So I want Cell A1 to show the sums of E2:E8 and Cell A9 to show the sums from E10:E39.

Is there a way I can do this without coding a macro?

 

[pgc01]

Hi
Welcome to the board

In column A, in the row after the last number in column E write a string (for ex. "End").

In G1 (or in another cell in row 1):

=if(a1="","",sum(e2:index(e2:index(e:e,rows(e:e)),-1+match(true,a2:index(a:a,match(rept("z",255),a:a))<>"",0))))

This is an array formula, you have to confirm it with CTRL-SHIFT-ENTER.

Copy down.

 

[asfau]

Thanks! I'll try it when I get back to work on Monday!