CODEWITHSUNDEEP
google-sheets
Алексей Наумов
Алексей Наумов

Reputation: 189

Google spreadsheet sumif adds, condition with string comparison

The task is to sum up the values of specific people. I have created the table, and found all the unique surnames. However, the formula's condition won't work.

Here is >>the example<<:

Here is the formula

=sumif(A2:A25,"=H2",F2:F25)

The exact formula is in red

A2:A25 the surnames "=H2" unique surname F2:F25 money

Upvotes: 0

Views: 41

Answers (1)

CodeCamper
CodeCamper

Reputation: 6980

You can't put a cell reference in a string...

=sumif(A2:A25,"="&H2,F2:F25)

Here is another way to do it as a bonus:

=query(A:F,"select sum(F) where A is not null and A = '"&H2&"' GROUP BY A label sum(F) ''",-1)

Upvotes: 1

Related Questions