Forum Discussion
Solved
How to Sum Cells with Text and Numbers in the Same Cell
Good Evening All - I am struggling to get a formula to work in Excel 365 that totals the numbers in a row of cells that have letters in the same cells. The cells have one of four letters (V / F / I...
Just for the fun of creating a formula that works in the situation you described, I came up with this:
=SUMPRODUCT(--(LEFT($A2:$F2,1)=H$1)*--(RIGHT($A2:$F2,LEN($A2:$F2)-1)))The attached workbook has a working example. Obviously, you need to adjust the cell references to your own situation. But, I must agree with mathetes that it is not good practise to combine letters and numbers into one cell if you intend to do calculations with the numbers afterwards. Possible, but not very practical.
Hello,
A classical solution is answered in the link below
https://www.extendoffice.com/documents/excel/2459-excel-sum-cells-with-text-and-numbers.html
A classical solution is answered in the link below
https://www.extendoffice.com/documents/excel/2459-excel-sum-cells-with-text-and-numbers.html