SUMIF with condition

[sheyy88]

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Mac[/TD]
[TD]10,000[/TD]
[/TR]
[TR]
[TD]Mac1[/TD]
[TD]20,000[/TD]
[/TR]
[TR]
[TD]Mac2[/TD]
[TD]30,000[/TD]
[/TR]
[TR]
[TD]Macy[/TD]
[TD]5,000[/TD]
[/TR]
[TR]
[TD]Macy1[/TD]
[TD]3,000[/TD]
[/TR]
[TR]
[TD]Macy2[/TD]
[TD]2,000[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]15,500[/TD]
[/TR]
[TR]
[TD]Mike1[/TD]
[TD]20,000[/TD]
[/TR]
[TR]
[TD]Mike2[/TD]
[TD]10,000[/TD]
[/TR]
</tbody>[/TABLE]

Hi, I would like to use formula to sum-up total for Mac, Macy and Mike. The formula I'm using is SUMIF(Column 1,"Mac"&"*",Column 2), but this formula will capture Macy as well.

Can anyone help?

Thanks.

 

[Fluff]

How about
=SUM(SUMIF(A:A,"Mac"&{"",1,2,3},B:B))

 

[sheyy88]

Thanks Fluff, it works perfectly!

 

[Fluff]

You're welcome & thanks for the feedback