I want to return the sum of all cells in ColumnA only if the value of a cell on the same row is equal to a specific value.

For example, sum C4 if D4 = "Bob". Assuming there are six rows whereby "Bob" appears in ColumnD, I would expect that the sum of six values from ColumnC would be added together.

My suspicion is the above requires use of a loop, which Google Spreadsheets does not provide.

2 Answers 2



in C column are numbers, in D column are ("bob" or others)

if you wish do not sum all column you can use for example


Note: Text is case sensitive (Bob is not equal bob)

  • 1
    It seems to me that sumif is case insensitive,
    – WAF
    Commented Nov 6, 2011 at 5:24

You can use this formula:

=if( D4="Bob",sum(A0:A0),"null")

This will sum all the values in the A column if D4 is equal to Bob, otherwise it will put a null as the answer.


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.