Ultimate Selector
Board Regular
- Joined
- Dec 15, 2013
- Messages
- 153
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>
</tbody>
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!
2-Jan | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
1 | 34 | 200 | 43 | -- | 97 | 27 | 33 | |
2 | 34 | 226 | 46 | -- | 99 | 46 | 37 | |
3 | 374 | 389 | 504 | -- | 625 | 396 | 455 | |
4 | 55 | 60 | 328 | -- | 154 | 66 | 57 | |
5 | -- | -- | -- | -- | -- | -- | -- | |
6 | 142 | 165 | 512 | 177 | -- | 157 | 136 | |
7 | 22 | 37 | 235 | 43 | -- | 91 | 37 | |
8 | 35 | 38 | 268 | 49 | -- | 95 | 38 |
<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>
</tbody>