# Formula That I Can Add, Subtract, Divide, Average, Etc, Etc These Numbers

Jun 19, 2008Imagine I have cells A1 to A5 with a sequence of "numbers" like this:

A1 = 50-55

A2 = 45-67

A3 = 56-90

A4 = 49-80

A5 = 51-55

The left hand side numbers represent a score a minus sign (-) to separate and the right hand side represent another score. I want a formula that I can add, subtract, divide, average, etc, etc these numbers.

If I want to add the left hand scores, for example, cells A1 to A3, sum would be 151 (50 + 45 + 56).