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.



--
Ron M

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

--
Carey Frisch
Microsoft MVP
Windows Shell/User

---------------------------------------------------------------

"Ron Mantle" wrote:

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.



--
Ron M

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.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/boo...x#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"Ron Mantle" <RonMantle@discussions.microsoft.com> wrote in message
news:1DBEE64B-94FD-4707-AEB0-D220273F9A57@microsoft.com...
>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.
>
>
>
> --
> Ron M

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&""))