Hi All,
I have problem that I think I am overcomplicating and was hoping I could get some advice please.
In my spreadsheet there are two pertinent columns. One is a dollar amount and the other is a description.
ex.
<tbody>
</tbody>
How can I get a total of all the cells that have a certain phrase in their description? I want to know how much came in from all credit card deposits but the last 4 digits are never the same. I can do an isnumber + search to indicate which cells match but then I have to use sumif and a grand total. I also did something similar with index + match.
Is there a cleaner way? I'm guessing it might be sumproduct but I can't figure out the syntax at all.
Thanks in advance!
I have problem that I think I am overcomplicating and was hoping I could get some advice please.
In my spreadsheet there are two pertinent columns. One is a dollar amount and the other is a description.
ex.
COIN | 0.71 |
CASH | 5.00 |
CREDITCARD4786 | 18.99 |
CASH | 4.00 |
CREDITCARD0887 | 103.74 |
<tbody>
</tbody>
How can I get a total of all the cells that have a certain phrase in their description? I want to know how much came in from all credit card deposits but the last 4 digits are never the same. I can do an isnumber + search to indicate which cells match but then I have to use sumif and a grand total. I also did something similar with index + match.
Is there a cleaner way? I'm guessing it might be sumproduct but I can't figure out the syntax at all.
Thanks in advance!