CODEWITHSUNDEEP
excelexcel-formula
horace_vr
horace_vr

Reputation: 3166

Reference a range of columns of an excel table but for a specified row

Building on this stackoverflow question (and it's answer), I am trying to reference a range of columns of an excel table, but I want to be able to control the row number. What would the syntax be?

For example, I tried to write the formula to only sum up the 2nd row of Table1:

I tried:

=SUM(Table1[[Column1]:[Column20]]2:2)

and

=SUM(Table1[[Column1]2:2:[Column20]2:2])

and they result in a warning that the syntax is wrong

Upvotes: 0

Views: 175

Answers (1)

Harun24hr
Harun24hr

Reputation: 36870

Try to transpose full table then return column to sum. Try below-

=SUM(INDEX(TRANSPOSE(Table1),,2))

enter image description here

Upvotes: 1

Related Questions