how to remove quote mark on an address formula

**ratjhman** · 02-23-2011, 10:17 PM

hi

I need some help here,
assuming value in cell S4 is 11 and value in cell S5 is 47, I've created this formula

Please Login or Register  to view this content.

the problem is, excel reads this formula like this

Please Login or Register  to view this content.

there is a double quotation mark (""), which is act like a string, so I can't get a summary from this formula. My question is, how to remove this quote mark so the excel read the formula as

Please Login or Register  to view this content.

Thanks for your help,
Regards,

Note : sorry I forgot to finish the subject title, it's my mistake

**Paul** · 02-23-2011, 10:38 PM

Hi Ratjhman, thanks for updating your thread title. As for your issue, perhaps this will work:

If you are trying to sum just cells J11 and J47, try:

=SUM(INDIRECT("Jan!J"&S4);INDIRECT("Jan!J"&S5))

If you are trying to sum all cells from J11 to J47, then try:

=SUM(INDIRECT("Jan!J"&S4&":J"&S5))

**ratjhman** · 02-23-2011, 11:04 PM

I've try to solved this issue from 2 days ago, and still get stucked. Yesterday I used "INDIRECT" too but still get stucked. You came just in second and whoaaa, it's work well. Thanks a lot Paul.