the formula below gives me the total in D1
in E1 i need to get the meters squared by multiplying each number individually by the qty in A1
is this possible?
=SUM(VALUE(CELLSPLIT(B1,",")))+SUM(VALUE(CELLSPLIT(C1,",")))
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Multiplying numbers separated by commas in multiple cells
- Thread starter mikeloz11
- Start date
the formula below gives me the total in D1
in E1 i need to get the meters squared by multiplying each number individually by the qty in A1
is this possible?
=SUM(VALUE(CELLSPLIT(B1,",")))+SUM(VALUE(CELLSPLIT(C1,",")))
