Google Sheets Formula Question

[AndyCr15]

I have a simple formula - =COUNTIF($B3:$FG3,"E")

I want to be able to define the column in a different cell to replace the 'FG' so I can change the range in which it's counting.

So lets say FH21 is the cell I will define the row, such as AA so the formula would then be =COUNTIF($B3:$AA3,"E")

Is this possible?

 

[MTA99]

INDIRECT should do it:

https://support.google.com/docs/answer/3093377?hl=en

I'm on the train but once in the office will check

 

[AndyCr15]

Thanks, I was trying to understand the INDIRECT command and tbh, I couldn't! (Not for how I want to use it anyway)