Forum Discussion
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"
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?
Rehanparkar I would just separate the texts from the numbers. That is, each in their own cells. Something like this:
- Thank 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
