Hi all!

How do I count the same range om several sheets?

Eg:

I want to count L4 to L8 on sheets 1 to 31,
by modifying this formula:
=COUNTIF('[DAILY REPORTS AND ROUTES.xlsx]1'!$L$4:$L$8,"CLIENT")

I have tried:
=COUNTIF('[DAILY REPORTS AND ROUTES.xlsx]1:31'!$L$4:$L$8,"CLIENT")
but it doesnt work.

Please help!