Adding a range with an empty cell

[Ultimate Selector]

I have a dynamic data input that at times has empty cells. Could be just one or more cells.
I simply want to auto sum or add up each row of numbers up and down. However, it wont add because when there is no data it is represented as (-) dash.
How do I get around this so it will ignore these cells with a dash? See example table.

Thanks for any help in resolving this issue for me!

<colgroup><col style="mso-width-source:userset;mso-width-alt:1442;width:31pt" width="41"> <col style="mso-width-source:userset;mso-width-alt:1373; width:30pt" width="39" span="8"> </colgroup><tbody>
[TD="class: xl67, width: 41"]2-Jan[/TD]
[TD="class: xl68, width: 39"]1[/TD]
[TD="class: xl68, width: 39"]2[/TD]
[TD="class: xl68, width: 39"]3[/TD]
[TD="class: xl68, width: 39"]4[/TD]
[TD="class: xl68, width: 39"]5[/TD]
[TD="class: xl68, width: 39"]6[/TD]
[TD="class: xl68, width: 39"]7[/TD]
[TD="class: xl68, width: 39"]8[/TD]

[TD="class: xl68, width: 41"]1[/TD]
[TD="class: xl69, width: 39"][/TD]
[TD="class: xl69, width: 39, align: right"]34[/TD]
[TD="class: xl69, width: 39, align: right"]200[/TD]
[TD="class: xl69, width: 39, align: right"]43[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39, align: right"]97[/TD]
[TD="class: xl69, width: 39, align: right"]27[/TD]
[TD="class: xl69, width: 39, align: right"]33[/TD]

[TD="class: xl68, width: 41"]2[/TD]
[TD="class: xl69, width: 39, align: right"]34[/TD]
[TD="class: xl69, width: 39"][/TD]
[TD="class: xl69, width: 39, align: right"]226[/TD]
[TD="class: xl69, width: 39, align: right"]46[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39, align: right"]99[/TD]
[TD="class: xl69, width: 39, align: right"]46[/TD]
[TD="class: xl69, width: 39, align: right"]37[/TD]

[TD="class: xl68, width: 41"]3[/TD]
[TD="class: xl69, width: 39, align: right"]374[/TD]
[TD="class: xl69, width: 39, align: right"]389[/TD]
[TD="class: xl69, width: 39"][/TD]
[TD="class: xl69, width: 39, align: right"]504[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39, align: right"]625[/TD]
[TD="class: xl69, width: 39, align: right"]396[/TD]
[TD="class: xl69, width: 39, align: right"]455[/TD]

[TD="class: xl68, width: 41"]4[/TD]
[TD="class: xl69, width: 39, align: right"]55[/TD]
[TD="class: xl69, width: 39, align: right"]60[/TD]
[TD="class: xl69, width: 39, align: right"]328[/TD]
[TD="class: xl69, width: 39"][/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39, align: right"]154[/TD]
[TD="class: xl69, width: 39, align: right"]66[/TD]
[TD="class: xl69, width: 39, align: right"]57[/TD]

[TD="class: xl68, width: 41"]5[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39"][/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39"]--[/TD]

[TD="class: xl68, width: 41"]6[/TD]
[TD="class: xl69, width: 39, align: right"]142[/TD]
[TD="class: xl69, width: 39, align: right"]165[/TD]
[TD="class: xl69, width: 39, align: right"]512[/TD]
[TD="class: xl69, width: 39, align: right"]177[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39"][/TD]
[TD="class: xl69, width: 39, align: right"]157[/TD]
[TD="class: xl69, width: 39, align: right"]136[/TD]

[TD="class: xl68, width: 41"]7[/TD]
[TD="class: xl69, width: 39, align: right"]22[/TD]
[TD="class: xl69, width: 39, align: right"]37[/TD]
[TD="class: xl69, width: 39, align: right"]235[/TD]
[TD="class: xl69, width: 39, align: right"]43[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39, align: right"]91[/TD]
[TD="class: xl69, width: 39"][/TD]
[TD="class: xl69, width: 39, align: right"]37[/TD]

[TD="class: xl68, width: 41"]8[/TD]
[TD="class: xl69, width: 39, align: right"]35[/TD]
[TD="class: xl69, width: 39, align: right"]38[/TD]
[TD="class: xl69, width: 39, align: right"]268[/TD]
[TD="class: xl69, width: 39, align: right"]49[/TD]
[TD="class: xl69, width: 39"]--[/TD]
[TD="class: xl69, width: 39, align: right"]95[/TD]
[TD="class: xl69, width: 39, align: right"]38[/TD]
[TD="class: xl69, width: 39"][/TD]

</tbody>

 

[Michael M]

You can select A1to A9 (which includes a blank cellfor the total)....then click on autosum !
Then drag cell A9 across as far as required.