Forum Discussion
Question related to sum(Text with Number)
Hello Everyone, I want to sum text with number. Like - IN COLUMN - IN ROW - The answer should be come in cell just written sheet with the help of formula Please help.? ...
I agree with Patrick2788; the dollar amounts should never have been held as text in the first place. Given that they are, in the days when I used non-array versions of Excel, I used Name Manager to bypass the fact that grid calculations mess with arrays. If 'input' is the row or column of input data, then defining the named formula 'amount' to refer to
=VALUE(MID(input,4,10))
or
=--(MID(input,4,10))
will give a well-behaved array of numbers.
The result is then given by
= SUM(amount)
with no CSE or curly brackets required. All that remains is to apply a number format such as
"USD" #,##0
[taking care to use the relevant parameter and thousands separators].
- Thank you so much for reply.
What is Input?- It is a Name I defined to refer to the row or column of data to sum.
It can either be done by typing the Name into the box on the far left of the formula bar or by opening Name Manager (Ctrl/F3) and defining the new Names.
It provides an alternative way of referencing data to the A1 notation and works well in Excel (the last time I used a direct cell reference was in 2015)- Thank you so much sir😊😊
- Thank you so much sir😊😊
