Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I tried to =SUM(INDIRECT("B4,B6")) but it doesn't work. How to do that?

share|improve this question
What formula are you using the INDIRECT range with? Remember, that returns those two exact cells as a single range, not two separate ranges. – Breakthrough Jul 28 '11 at 17:10
In pt-BR I use =SOMA(INDIRETO("B4;B6")) – Jader Dias Jul 28 '11 at 17:10
@Breakthrough edited to provide your answer. – Jader Dias Jul 28 '11 at 17:12
the SUM function only takes continuous cell ranges as its arguments. – Breakthrough Jul 28 '11 at 17:17
@Mehper C. Palavuzlar each argument has to be a continuous range. What you posted in your answer further proves my point, since you did not specify a non-continuous range for any argument, but rather, they are all continuous. – Breakthrough Jul 28 '11 at 17:30
up vote 3 down vote accepted

It works this way:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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