Hey guys.
I need a formula to lookup the sales orders then add the amounts so it equals 118.00 in the "TBD" cell.
<tbody>
</tbody>
I could "Convert text to number" but my Excel file has 1 thousand lines, and sometimes there are 50 numbers in a single cell.
Thanks guys
I need a formula to lookup the sales orders then add the amounts so it equals 118.00 in the "TBD" cell.
Sales orders | Total amount | Sales orders | Amount | |
123456789 / 234567890 | TBD | 123456789 | 56.00 | |
234567890 | 62.00 | |||
Total | 118.00 |
<tbody>
</tbody>
I could "Convert text to number" but my Excel file has 1 thousand lines, and sometimes there are 50 numbers in a single cell.
Thanks guys