Sum from an indexed array/table
 

Hi

Could you please help me with this? I want to sum cells
in a row that are within an array/table that is indexed.
I first need to locate the desired row in the index and
then sum the cells.

Thanks for the help.

..

Try:

=SUM(INDEX(mytable,X,))

where X = the row index.

HTH
Jason
Atlanta, GA

" wrote:

Hi

Could you please help me with this? I want to sum cells
in a row that are within an array/table that is indexed.
I first need to locate the desired row in the index and
then sum the cells.

Thanks for the help.

..