Formula to Convert Sum Text to Formula

R

Ron Mantle

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.
 
C

Carey Frisch [MVP]

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

--
Carey Frisch
Microsoft MVP
Windows Shell/User

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

:

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.
 
B

Beth Melton

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/books/9801.aspx#AboutTheBook

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

undisclosed

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

You need to install morefunc before using the function eva

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