CODEWITHSUNDEEP
excelvbarownamed-ranges
user3925803
user3925803

Reputation: 3295

Excel using INDEX to get row from named range causes formula error

I have a very simple formula to get the sum of values in a row:

=SUM(K5:P5)

However, K5 to P5 is the first row in a named range, and I would prefer to reference the named range, so I change it to:

=SUM(INDEX(S2ScoresTotUnitQ1,Row("A1"),0))

But I get a "we found a problem with this formula error". How do I reference individual rows of my named range without getting an error?

Upvotes: 3

Views: 918

Answers (2)

Vityata
Vityata

Reputation: 43575

The column in the Index formula is an optional argument, you do not have to pass it, if you do not wish. Thus, something like this should work:

=SUM(INDEX(S2ScoresTotUnitQ1;1;))

Whenever the formula has these [ and ] like here, it is optional argument: enter image description here

Upvotes: 0

Harun24hr
Harun24hr

Reputation: 36850

Remove double quote from A1 referrence. Means Row("A1") will be Row(A1). So, formula will be as following

=SUM(INDEX(S2ScoresTotUnitQ1,ROW(A1),0))

Upvotes: 3

Related Questions