Formula to Convert Sum Text to Formula

I have the follwoing formula in cell.
=+O7&N7&":"&P7&N7&")"
It returns the value:
=SUM(B7:C7)
in a text format.
Is there a formula to convert this cell to produce the actual sum of the
numbers.

I'm trying to total a row of numbers JAN thru DEC, based on a single cell
that indicates which month it is.

The proper newsgroup for questions regarding Microsoft Excel
is the Excel newsgroup:
http://www.microsoft.com/office/comm...&lang=en&cr=US

I'm not sure if I follow exactly what you are trying to do but I think you
need to use a SUMIF function or perhaps a Pivot Table?

Also, if after looking into both of these if you have any follow-up
questions you'll find a broader Excel audience by posting to one of the
Excel newsgroups. :-)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

I think I'm a little late. But will help future issue like this.

You need to install morefunc before using the function eval

=SUM(EVAL(+O7&N7&":"&P7&N7&""))