Hi there i need to divide multiple percentages by the total of cells with the data in.But I also need to display the data in one cell.
for example;
Total cell Formula
A1=98% B1=95% = BB1 = 96.50% (=SUM(A1:B1)/2)
A1=98% B1=95% C1=97% = BB1 = 96.67% (=SUM(A1:C1)/3)
A1=98% B1=95% C1=97% D1=99% = BB1 = 97.25% (=SUM(A1:D1)/4) ...ETC

But i need to do this 52 times.

So what I want to know is, is there a way of BB1 constantly changing in accordance to how many figures are entered across the cells A-BA.
So if I only have 14 cells with data in then;
BB1 will be =SUM(A1:N1)/14
OR
31 cells with data in:
BB1 will be =SUM(A1:AE1)/31

Also the data is coming form another sheet in the document if that changes anything

Kind Regards

Deano3141