Division

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

Thanks for the help. i have just tried it and it hase given me
A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1
98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00%
TOTAL
26.33%
surely it should be 98

Hi thanks. it works a treat.

Hello again the code =Sum(A1:BA1)/Count(A1:BA1) is working a treat however in the cell it is displaying #DIV/0!.
I thought if I put an If statement at the beginning that it would return the figure to 0 however it comes up with #VALUE.

=IF(A1:BA1= 0,0,SUM(A1:BA1)/COUNTIF(A1:BA1,"<>0"))

PLEASE HELP

Thanks I've managed to do it myself.
=IF(COUNTIF(B3:B3,"<>0")=0,0, (SUM(B3:BA3)/COUNTIF (B3:BA3,"<>0")))

Sent from my GT-I9300 using Tapatalk