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
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