There are two other methods to use the INDIRECT function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear. Inside the ...

Excel's INDIRECT function turns a text string into ... First, we will use the COUNT function to work out how many games the team has played so far. Typing =COUNT(B:B) into cell E1 will count ...