Hi All, Further to your most welcome assistance I now have a dynamic range
that works, enabling me to add an additional row to the sheet, and then
simply add 1 to the Row Value in A1 for all the formulae to update.

=COUNTIF(OFFSET(J49,0,0,$A$1-ROW(J49)+1,1),"Yes")/COUNTA(OFFSET(J49,0,0,$A$1-ROW(J49)+1,1))*100

Is it now possible to make the start point, e.g J49, a dynamic range as
well, that I can move this forward by adding 1 to a Row Value in say A2 ?
Any advice much appreciated.