Forum Discussion
Excel
Apr 11, 2021Iron Contributor
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.? ...
Excel
Apr 11, 2021Iron Contributor
Thank you so much for reply.
What is Input?
What is Input?
PeterBartholomew1
Apr 11, 2021Silver Contributor
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)
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)
- ExcelApr 11, 2021Iron ContributorThank you so much sir😊😊