ID | Amount |
Mac | 10,000 |
Mac1 | 20,000 |
Mac2 | 30,000 |
Macy | 5,000 |
Macy1 | 3,000 |
Macy2 | 2,000 |
Mike | 15,500 |
Mike1 | 20,000 |
Mike2 | 10,000 |
<tbody>
</tbody>
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.