How to put into formula form

[madfc101]

in Column B I have a list of text strings. in Column c I have a list of lengths that go to column B.

beneath I have all the sums and lengths.

How to I put in formula If certain word pops up in column B. Sum all above that row in Column C

example: how can I make it sum all above jars.

col B col C
pipe 1 30.31
pipe 2 32.42
jars 40.91

 

[LloydFinancials]

Welcome madfc101,

In the example above the sum would be 62.73. Based on that I created the following for you.

Excel 2010
	A	B	C	D	E
1	col B	col C		pipe 2	30.31
2	pipe 1	30.31
3	pipe 2	32.42
4	jars	40.91
5	jars 2	29
6	wire 1	31
7	wire 2	5
Sheet1

Cell Formulas
Range	Formula
E1	=SUM(INDIRECT((ADDRESS(MATCH(D1,$A$2:$A$100,0),2)&":$B$2")))

Best,

Luke