Forum Discussion
ADDING IN THE SAME CELL
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??
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)