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!
Bookmarks