Hiya Pecoflyer,
Whatever I tried I could not get the syntax correct for a INDIRECT statement and therefore came up with a cunning workaround.
I created another formula in the worksheets (B13) that had the formula =IF(B3>0,1). Refer to the attached screenshot but this basically changed its value from FALSE to 1 as soon as the first score went in. From here I was able to write into the formulas to only include the worksheet if B13 = 1
|