Array Formula Clarification

BBlu
BBlu used Ask the Experts™
on
From what I understand, the following should return an array of the second row in the index function's first parameter.  My question is, if I array enter a sum of this function, shouldn't it work?  It's returning a #REF!

=SUM(INDEX($H$17:$K$23,2))
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Actually, your formula should be:

=SUM(INDEX($H$17:$K$23,2,))

Note the extra comma.

That will return the correct answer whether entered regularly or as an array formula.

Author

Commented:
Thanks, Matthewspatrick.  So I need the extra comma even if there is no column reference.  Got it.
Top Expert 2010

Commented:
It's the extra comma, followed by no column reference, that tells Excel that you want Row 2 from the indicated range.

Author

Commented:
Awesome!  Thanks, again.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial