Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
2  
the SUM function only takes continuous cell ranges as its arguments. –  Breakthrough Jul 28 '11 at 17:17
1  
@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
show 2 more comments

1 Answer

up vote 3 down vote accepted

It works this way:

=SUM(INDIRECT("B4"),INDIRECT("B6"))
share|improve this answer
add comment

Your Answer

 
discard

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.