Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM C IF B=Cap...TILL NEXT B=Cap... | Excel Worksheet Functions |