CODEWITHSUNDEEP
excelexcel-formulasum
Umut K
Umut K

Reputation: 1388

Sum of table column by cell name

I have a table, table headers and some number under the header.

I want to write a dynamic formula which will get the sum of the column under each header.

instead of 

=SUM(Subeler[MERKEZ OFIS])

I want a formula to replace the name of the header, something like :

=SUM(Subeler["C6"])

the header is on C6 cell.

Why I need this :

  1. each time the header may change which is coming from powerquery
  2. I need the sum, somewhere on the top of the table

Upvotes: 1

Views: 584

Answers (1)

Umut K
Umut K

Reputation: 1388

in C5 cell , i wrote the formula

="Subeler["&C6&"]"

then in the cell i have this formula :

=Sum(indirect(c5))

it was so simple but i've just figured it out...

Upvotes: 1

Related Questions