Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Google Spreadsheet, I would like to find a column using a variable matching the column header and sum the column if the match is found.


Ref | X  | Y  | z |
A   | 3  | 4  | 2 |
B   | 2  | 1  | 2 |

What I need is to sum all of one column or all of one row (eg. B), not by referring directly to the row reference but by looking up "B" (or filtering "A" out).

How can I do that?

share|improve this question

You can use the following formula to accomplish that.


=SUM(INDIRECT(B1 & ":" & B1))


This formula can be used for rows and columns a like. It simply combines the input into a text range, that's being converted into a readable range, through the INDIRECT function.


enter image description here


I've prepared an example file for you: sum column by referencing column header

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.