Good Morning,

Need a little help, using the below formula in my spreadsheet

=IF(COUNT('LC Raw Data'!B2:B13)=0," ",AVERAGE('LC Raw Data'!B2:B13))

The problem is that i need the range to jump to the next block of data ie

=IF(COUNT('LC Raw Data'!B14:B25)=0," ",AVERAGE('LC Raw Data'!B14:B25))

and so on. Without having to manual adjust the range.

Cheers in advance K.