What I want to do is add a column to give me a total.
But in some of the colums I have two numbers with one of these in brackets.
For example 18 (23) given me a total for that cell as 41.
If I do an auto sum it actually takes away 18 from my overall total.
But I want my total to include both numbers.
Is there an easty way round this?
But in some of the colums I have two numbers with one of these in brackets.
For example 18 (23) given me a total for that cell as 41.
If I do an auto sum it actually takes away 18 from my overall total.
But I want my total to include both numbers.
Is there an easty way round this?