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,",")))
B and C should total 9.49 m2This doesn't make sense to me. Can you show the manual calculation?
That will only work if the number in A2 is always 1, it never multiplies that value.Thank you so very very much! that worked perfectly!
greatly appciated!