Forum Discussion
Rehanparkar
Sep 18, 2023Copper Contributor
How to calculate the sum of the cells which includes both numbers and word
In the attached screenshot "I want the total to show as 20 but it is only calculating numbers"
Rehanparkar
Copper Contributor
Thank you for your reply
do you have any other suggestion for me to record where i can show word and number both in the same cell and the sum will show up the actual total?
do you have any other suggestion for me to record where i can show word and number both in the same cell and the sum will show up the actual total?
Riny_van_Eekelen
Sep 18, 2023Platinum Contributor
Rehanparkar I would just separate the texts from the numbers. That is, each in their own cells. Something like this:
- RehanparkarSep 18, 2023Copper ContributorThank you for the suggestion, but my requirement is to show the text and number in the same cell
thank you for your formula, it worked..appreciate it