How can I sum numbers in a specific range, determined by the cells value

**avelinov** · 02-13-2012, 03:59 AM

Hi,

I have the following example:
A B C D
b 0 0a 01
a 1 1a 11
a 2 2b 22
3 3c 33
a 4 44
a 5 1b 55

So I want to sum all numbers in column D from a specific range. The range is - first row, where column C is 0a to the first blank cell in the same column and A cells value = a.
In my example the sum = 11+22

Can you help me with the formula? Thanks.
I can try to explain it better, if was not clear enough. Thanks!

**zbor** · 02-13-2012, 04:13 AM

After first blank in C column, can there be more data or all other cells are blank too?

**avelinov** · 02-13-2012, 04:25 AM

There is more data after first blank.

**zbor** · 02-13-2012, 04:43 AM

How about this with aditional column:

Now in some separate column you can use MAX(E:E) or something to get 33.

If blank is before 0a you will get #N/A. If there is no blank you will get blank.