ADDING IN THE SAME CELL

Copper Contributor

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??

1 Reply

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)