OK now I see, but one more question

[Mike Busch]

Thanks for th aanswer. I fooled around with the average
formula, and it gave me exactly what I needed. If I did
not place a count in a cell in ignored that cell in the
average. Ok my next question is how do I set up a
worksheet to give me the average of all counts over this
two week period on all the worksheets I have created. I
tried =AVERAGE('Sept 13'!C6:C12+'Sept 14'!C6:C12+'Sept
15'!C6:C12)but there was an error here. Again any help..
thanks again.

 

[Frank Kabel]

Hi
try replacing the '+' sign with a coma