Sum comma delimited numbers
If you had comma-delimited values in cell A1 then the following function will return the sum of these values. EVALUATE(SUBSTITUTE(A1,",","+")). It basically replaces the commas with plus signs and then evaluates.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top