Try it using COUNTA rather than COUNT.

Excel is not very good with 3-D stuff, so if:

=COUNTA(week1:week4!C56:C60)

doesn't work you might have to try it like:

=COUNTA(week1!C56:C60) + COUNTA(week2!C56:C60) + COUNTA(week3!C56:C60)
+ COUNTA(week4!C56:C60)

Hope this helps.

Pete

On Apr 28, 4:56*pm, Kimmie40 wrote:
On Apr 28, 10:41*am, Pete_UK wrote:

Sometimes the easy ones are the most elusive !!

Thanks for feeding back.

Pete

On Apr 28, 3:31*pm, Kimmie40 wrote:

Wow....duh...thanks Pete. * That was so easy its embarrassing- Hide quoted text -

- Show quoted text -

Pete, can you do the same for cells populated with text...not numbers?