Check for and count instances of text

[Prelude]

Hey all, my problem is this:
I have a subtotal category and another column for text that says what account the subtotal was put into. For example, $80, Savings. I want to set up a calc that looks for all the “savings” texts, then adds the amounts listed beside savings into a Total category. This is so I can see the total for the Savings account and the other accounts without having to manually add up all the subtotals myself.

I see there are “find” and “search” functions, but I can’t seem to make them work. Am I on the right track in using those functions to solve this problem or is there a better way? Thanks in advance

[LeroyG]

=SUMIF(B1:B3;B5;A1:A3)

LibreOffice help on SUMIF function.

[Prelude]

I tried what you suggested, I can’t seem to make it work. Here’s a screenshot of what I’m looking at

[joshua4]

@Prelude, thanks for visiting. Screenshots are pretty minimal info. Can you go ahead and upload your sample using the up arrow icon?

From what I see, I’m not sure you have the idea of the $B$5 in LeroyG’s example. That is what you are comparing to, the type of account. You could put Popo in there, and your sum would be 50. Check out $E5 in the example ODS attached regarding the E5 vs $E$5 vs $E5.

SimpleSUMIF.ods (16.2 KB)

[Prelude]

This worked! Thanks for your example, that helped me understand what he was saying. Thanks a lot!