# Suming cell values according to another cell 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!

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)
``````

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