Urgent excel problem

[A[L]C]

Hi all,

Ive got a worksheet with lots of questionaires imported in to it. The format of each sheet is the same. On the summary sheet, how would I say the total of all non-blank cells in rang C4 for all other sheets? There will be a few hundred sheets so its not feasable to make a huge formula??

Thanks

 

[A[L]C]

dont worry done it