Hello Ever1 !
i have tried few formula from forum to extract number from data in cell, it gets attracted but cannot sum as it is extracted as text.
Please any one can share formula in which number can get extract and i can sum them also.
Thanks in advance from newbie
i have tried few formula from forum to extract number from data in cell, it gets attracted but cannot sum as it is extracted as text.
Please any one can share formula in which number can get extract and i can sum them also.
Thanks in advance from newbie
Extract Number & Sum.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Date | Result | ||
2 | 0.07 DR | 0.07 | ||
3 | 2.61 DR | 2.61 | ||
4 | 20.00 DR | 20.00 | ||
5 | 4.08 DR | 4.08 | ||
6 | 70.00 DR | 70.00 | ||
7 | 0.07 DR | 0.07 | ||
8 | 0.07 CR | 0.07 | ||
9 | 2.61 CR | 2.61 | ||
10 | 20.00 CR | 20.00 | ||
11 | 4.08 CR | 4.08 | ||
12 | 70.00 CR | 70.00 | ||
13 | 0.07 CR | 0.07 | ||
14 | Total | 193.66 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B14 | B14 | =SUM(B2:B13) |