Hi, I need help.
I've created an excel sheet with a drop down list which includes numbers (and letters) in brackets. Eg: 8 (AL), 16 (AL) etc. See attached picture
I need to create a formula that sums only the numbers in a column of cells excluding any letters or a cell with a only a letter. I dont want to split the cell as I need the drop down lists to include the letters as to specifiy something. I'll be using conditional formatting with the letters such as AL \ LSL
Can anyone help?
Grant
Bookmarks