Sum from another worksheet formula help

[jcaptchaos2]

I have this formula which sums a column from another sheet and am using it on a summary sheet. I have this formula in cell C15 on my summary tab, I have the sheet name "General" in cell B15, what I would like is a formula to look at Cell C15 and then go to the proper sheet tab in this case "General" and sum M7:M82.

=SUM(general!M$7:M$82)

 

[jim may]

In your cell C15 enter:

=SUM(INDIRECT("'"&B15&"'!M$7:M$82"))

 

[jcaptchaos2]

Ah very cool, Thanks Jim.