Aug 26 2019 07:55 AM
I have a list where I can add up at the end, but I also want to be able to add say 42+98+67 in the same cell. How do I do this??
Aug 26 2019 09:51 AM - edited Aug 26 2019 09:53 AM
I would not appear to achieve that much but if you turn the text into a formula by inserting an equals sign
=42+98+67
the formula will evaluate based on the embedded constants. Other forms include summing an array constant
= SUM( {42,98,67} )
or SUM with three individual parameters.
= SUM(42, 98, 67)