Home > Mobile >  Why does Sheets/Excel allow entering in SUMing cells with string values but not strings themselves?
Why does Sheets/Excel allow entering in SUMing cells with string values but not strings themselves?

Time:08-08

I've noticed the following:

enter image description here

Basically, I can do:

=SUM(range)

When that includes a cell, and also the individual cells:

=SUM(cell1, cell2, ...)

But when I enter in the literal values it gives me an error if they're not all numeric:

=SUM(val1, val2, val3)

Why is this so?

CodePudding user response:

in google sheets, if you want to pass a text string as an argument you can do:

=SUM(10, 20, 30, N("Hello"))

enter image description here

some people tend to use this in their complex formulae (not just SUM) as notes

enter image description here

  • Related