Sum all columns with a certain word within a cell.

[tcorcoran15]

Hello,

I am currently trying to combine a sumif and a right formula however I am at the stage where I am unsure if I am able to.

I have multiple descriptions in column A and each description ends with a specific word like as follows:

A	B
Tom - Red	1
Tom - Blue	5
Harry - Red	3

<tbody>
</tbody>

I would like to create a formula to sum up column B for all the ones which right(A1:A3,3)="Red" so in this instance it would give me 4 as the total. Is this possible?

Thanks in advance for any help.

 

[AlanY]

try

=SUMIF(A1:A3,"*Red",B1:B3)

 

[tcorcoran15]

Works perfect, thanks for your help!

 

[AlanY]

Works perfect, thanks for your help!

you're welcome