Consider the following spreadsheet:

enter image description here

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!

1 Answer 1


You can use a SUMIF statement.

The syntax is as follows

SUMIF(range, criterion, [sum_range])

In your case, you want to sum the A column, but only where the corresponding row in the B column contains "Conta - Casa"

The formula you would use is:

=SUMIF(B:B, "Conta - Casa", A:A)

You can read more about SUMIF here.

Here's an example I did with the following formula

=SUMIF(B:B, "bar", A:A)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.