the problem i have is my YTD average has DIV/0! error , i want the ytd average to ignore months that haven't been input yet. e.g BJ hands per hour in Jan=70 so at this point the ytd av. should also be 70.the ytd average will only work when all months have values, i have tried the formula:

=AVERAGE(H42:J42,L42:N42,P42:R42,T42:V42,X42:Z42,AB42:AD42)/COUNTIF(H42:J42,L42:N42,P42:R42,T42:V42,X42:Z42,AB42:AD42,''<>0'')

and just get the error mesage:

You've entered too many arguments for this function.

H42:J42 is Roulette av. spins p/h, BJ Av Hands p/h and 3 card poker Av H p/h in january and so on.

I have only 6 months in the sheet so far to get the formulas working first.