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:

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]Tom - Red
[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]Tom - Blue[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]Harry - Red[/TD]
[TD="align: center"]3[/TD]
[/TR]
</tbody>[/TABLE]

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