Consider the following spreadsheet:
I want to sum every cell on column A that shares the same value on the same row on column B.
For instance, I want to sum all A cells whose respective B cells have "Conta - Casa" in them.
I have almost 0 knowledge on spreadsheets, I'm not even sure I'm making myself clear explaining my problem.
EDIT: Thank you very much WELZ!, that just did the trick!
One note, though: both your example and the example given by Google Sheets documentation did not work for me and I lost a good 10 minutes figuring out why.
For pt-br locale reasons, arguments in the formula must be separated by semicolons, not commas. I found that out by looking at the pt-br version of the same documentation here: here. Weirdly enough, when I try typing "SOMASE", the pt-br translation of "SUMIF", on a cell, sheets translates it back to it's english counterpart.
Thank you very much!