Why does this formula work?
it’s equivalent to
The creator of this formula wanted
It’s funny how formulas can trick you. The first formula entered was
and since B2:B11 were all zeros, it appeared to give the right answer. To be fair, it did give the right answer, but it appeared to be summing the correct cells, which it was not. I thought he had discovered a new union operator or something. Then the formula was copied one cell over. With columns B and D being all zeros, it was perplexing how he was getting a non-zero result.
Anyway, it seems like that first formula shouldn’t even parse. One colon per argument should be the rule.
On another note, should I say “B2:B11 were all zeros” or “B2:B11 was all zeros”?