Hi,
In Excel i need to add numbers in a row together but the problem i have it that in the cells are occasionally words.
for example:
|viks 10|steve 6|
is there a way i could get excel to look at that but answer 16? At the moment i am using Sum and it comes up with 0.
Thanks
Viks
In Excel i need to add numbers in a row together but the problem i have it that in the cells are occasionally words.
for example:
|viks 10|steve 6|
is there a way i could get excel to look at that but answer 16? At the moment i am using Sum and it comes up with 0.
Thanks
Viks