0

SUMIF is letting me down "selectively" and I'm not sure why (or I am letting SUMIF down, not sure which).

Please see two spreadsheet examples:

This one with original sample data.

And this one with a smaller made up set.

I am using the exact same formula in each:

=SUMIF(B2:B,"rdc",C2:C)

On one sheet it works, on the other, well, not so much.

3

If you are after any cell which has ONLY "rdc" (without the quotes), then your formula is fine. If you want any cell which has rdc anyplace in the string, then change it to:

=SUMIF(B2:B,"*rdc*",C2:C)

If rdc should stand alone, and not be in the mniddle of a word, then

=SUMIF(B2:B,"* rdc *",C2:C)

For cells starting with rdc:

=SUMIF(B2:B,"rdc*",C2:C)

Basically, you need to add a wildcard. Then there is the question of what about upper case letters? These are not case sensitive.

| improve this answer | |
  • Thanks Karl! I wasn't aware of this feature. I'm all lower case, but what would you recommend for fielding mixed case? – Drewdavid Feb 8 '17 at 16:14
  • I would use a =sum(query()) combination something link: =sum(query(B2:C, "select C where B contains 'rdc",0')) I believe this may return a case sensitive result. – Karl_S Feb 8 '17 at 16:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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