Google Sheets Formula Question

Soldato
Joined
28 Apr 2011
Posts
14,762
Location
Barnet, London
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?
 
Back
Top Bottom