Hi,
I want to calculate a Sum/Total of all those cells that also contain some text strings For example:
Cell A1 has
"ABC-2"
Cell B1 has
"DEF-3"
Cell C1 has
"XYZ-5"
So the total would be 10
But as this an example, it is pretty easy to calculate this manually but i have a long list of alphanumeric values. The good part is, these numbers are separated by a hyphen (-).
I need a excel formula/function to do this calculation. Please help me out.![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I want to calculate a Sum/Total of all those cells that also contain some text strings For example:
Cell A1 has
"ABC-2"
Cell B1 has
"DEF-3"
Cell C1 has
"XYZ-5"
So the total would be 10
But as this an example, it is pretty easy to calculate this manually but i have a long list of alphanumeric values. The good part is, these numbers are separated by a hyphen (-).
I need a excel formula/function to do this calculation. Please help me out.
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)