I am currently trying to add data together to get a total, once slight snag
the data is set out within different cells which are made of of individual
figures for different days.

Example

16/07/07 17/07/07 18/07/07
1 - 1 - 3 1 - 1 - 3 1 - 1 -3

So I want my totals to be 1 + 1 =3 from cell A1 through to A3 but my total
would be 3 - 3 - 9 as the first two positions represent say total blue pens
and red pens and the last position gives me the over all number of pens we
have in stock.