Adding columns containing numbers with dashes
Hi Randi,
Assuming your data is in A1:A4
In B1 put =SUM(LEFT(A1:A4,2)*1)
and in C1 put =SUM(RIGHT(A1:A4,1)*1)
Both formulae are array formulas so must be committed with
Ctrl+Shift+Enter and not just enter
HTH
Martin
"Randi" wrote in message
...
I have several columns (formatted as text) containing numbers with
dashes, i.e.,
20-1
15-2
30-4
05-3
Is there a way to add up the numbers separately in the column, i.e,
one total for the 20, 15, 20, 05 and one total for the 1, 2, 4, 3. If
unable
to add both is it possible to add up just the numbers to the left of the
dash? Thanks.
|