sumif question

B

Betaman

I want to sum the values in a column if the text in a different column same
row CONTAINS a certain word. ie the text doesnt have to match exactly just
include that word. Is the anyway to do this?
Cheers,
Steven
 
R

Rita Palazzi

=SUMIF(a5:a10,"*TEXT*",b5:b10)

a5-a10 is text field to measure
b5-b10 is value to add if true
 
Top