E

#### eidde1

I hope this someone can help with this

In column G I have a "Total" column Column I has a text string (Heading of "Result" as below

Total Result

25 Apples 10 Oranges 3 Grapes 12

15 Melons 10 Grapes 5

Oranges 8 Grapes 18

So basically sometimes the value is missing in the "Total" which is the sumof the numbers in the Results column. I would like some code to add the numbers in the result column and only add it to the total column if no value is entered. So the result would be

Total Result

25 Apples 10 Oranges 3 Grapes 12

15 Melons 10 Grapes 5

26 Oranges 8 Grapes 18

Many thanks for any help