I have this excel table and I want to SUM some values from a column depending on what value they have on the column to the left.

The values from the right that have "Overall Results" on the left, are the ones that I need to SUM.

I have tried some conditionals but none of them work, any ideas?

enter image description here

  • Your title states "formula not working". What formula have you tried? – CharlieRB Nov 8 '13 at 18:19
  • It was a very similar formula to the one douglaspls posted, but I wasn't entering the sum_range correctly – elunicotomas Nov 8 '13 at 18:36

Try this:

=SUMIF(Cells on the left;"Overall results";Cells on the right)

Check this example:enter image description here

=SUMIF(A1:A5;"Overall results";B1:B5)

Note: As mentioned by @CharlieRB you should used comma , instead of semicolon ; depending on you region.

  • Your formula will not work with ;. It needs to have , (commas). – CharlieRB Nov 8 '13 at 18:27
  • @CharlieRB I think it depends on the (geographical) region in which excel is being used. In some regions i believe, ";" is the default delimiter in a formula as opposed to ",". – Jaycal Nov 8 '13 at 18:29
  • @Jaycal is correct. It depends on your region. Do you think I should still change it to commas? – douglaslps Nov 8 '13 at 18:31
  • At least make a note of it in your answer in case someone is not in the same region as you (like me). Good answer, by the way! – CharlieRB Nov 8 '13 at 18:35
  • I was having this problem! I'm in Argentina, I have Office in English, and the computer language in Spanish, in all that mess I have to use "," – elunicotomas Nov 8 '13 at 18:37

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.