CODEWITHSUNDEEP
excelexcel-formula
Ksenia
Ksenia

Reputation: 497

Formula with obviously correct syntax still returns an input error

I'm totally stuck - the below array formula copied from the respected source:

=SUM(LARGE(A:A,ROW(INDIRECT(“1:10”))))

produces an error during the input:

The formula you typed contains an error.

Sure thing I press CTRL+SHIFT+ENTER. Obviously that should be something too simple to notice. TOO simple for me)

Upvotes: 3

Views: 975

Answers (1)

Maks Gordeev
Maks Gordeev

Reputation: 351

I'm not 100% sure, but as soon as you copied the formula from somewhere (perhaps web or PDF or whatever) - check the quotes!

Many times I got stuck with exactly the same: double quotes with codes 147 & 148 look way too similar to "plain" ones, i.e. CHAR(34) which are generated in Excel while typing. However, only the last ones are acceptable for using in formulas. So..... check these first! ;)

Upvotes: 5

Related Questions