For a specific text thead, Finding the sum of corresponding column

[ryanl812]

Can anyone help... I am looking to define the sum of a set of values that correspond to a specific text string in another column.

For instance, in rows A1:A6, if the term "Hello" is used, I would like to see the sum of the corresponding values in rows B1:B6. If a different word in A1:A6 is used then the value in B1:B6 would not be used.

I have been playing with a couple of options, but can't seem to break out the total of just the corresponding rows. Would love to get some feedback.

This doesn't work, but it's a starting point perhaps -
=SUMPRODUCT(IF(F2:F109="TSS",B2:B109,0))

Thanks,

-Ryan

 

[Domenic]

Try...

=SUMIF(F2:F109,"TSS",B2:B109)

 

[ryanl812]

Aaah - that's it! Thanks so much for the help!