Discussion Locked

Excel 2002 /2000 convert Value to Range-of-cells

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

need support for Excel 2000 or Excel 2002 to convert cell range
from data in Cell.
i.e cell A5 have data E10:E35
How can I use this info in SUM function?

=SUM(A5) does not work
=SUM(TEXT(A5),"") does not work

evaluate error shows =SUM("E10:E35","") but does not do the sum?

Please advise solution mspatel@ntlworld.com

3 replies

This discussion is closed to new replies.