Hi,

I used the following in a spreadsheet over a year ago and can't remember
how, why, or what I've done. Head spinning because I'm making unexpected
changes which were needed "Now, if not sooner"
The formula below is entered as an array formula but don't know why
{=IF(ISERROR(AVERAGE(IF(Score0,Score))),"",AVERAG E(IF(Score0,Score)))}
Named range "Score" is a dynamic range as below
=OFFSET('Sheet1'!$Q$1,0,0,COUNTA('Sheet1'!$Q$1:$Q$ 35),1).
If anyone can help I would be grateful :-)

Cheers
Diddy