Text Reference in Cell

[grifdoogindoggy]

Is it possible to reference a cell for it's text? The problem I am trying to fix is the following:

=SUMPRODUCT(COUNTIF(January!E36:E36,{"Completely Satisfied","Very Satisfied"}))

I am not in the January sheet. However, the cell E36 in the sheet I am in contains "AI", which is actually the cell (column) that I want to be referencing.

So I want it to be =SUMPRODUCT(COUNTIF(January!AI:AI,{"Completely Satisfied","Very Satisfied"})) by referencing the text I have in the E36 cell.

Is this possible?

Thank you.

 

[DanteAmor]

Try this:

=SUMPRODUCT(COUNTIF(INDIRECT("January!"&E36&":"&E36),{"Completely Satisfied","Very Satisfied"}))

 

[grifdoogindoggy]

Hey thanks! I thought indirect had something to do with it!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.