Hello Bob Phillips
Thanks for your post.
I understand your function, it is intelligent, all the tests of the enclosed
functions give accurate results - selecting and typing F9, as you know-, but
the final result always gives the error "# VALUE".
Have you tested it?
Arcindo Lucas

"Bob Phillips" escreveu:

This should work as long as you have Cap in the last row of data + 1

=IF(LEFT(B2,3)="Cap",SUM(OFFSET(C3,0,0,MATCH("Cap" ,LEFT(B3:$B$100,3),0)-1)),
"")

it is an array formula so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"cradino" wrote in message
...
Having data below in an excel spreadsheet how can I make a unique formula
in
column D that gives in lines where the text in Column B begins with "Cap"
the
sum of column C till next line where B begins with "Cap" ????

Best Regards, and Thanks for Help

Correction:
A1 B2 C2 D2 E2
A2 Cap1 63 '=SOMA(C3:C5)
A3 10
A4 21
A5 32
A6 Cap2 41 '=SOMA(C7:C8)
A7 8
A8 33
A9 Cap3 44 '=SOMA(C10:C12)
A10 33
A11 6
A12 5
A13 End


--
Arcindo RA Lucas