Will ther be any instances of H1 in between the specified ranges? If not, why not use:
=COUNTIF('Panel Draw'!B11:T223,"H1"), or even:
=COUNTIF('Panel Draw'!B:T,"H1")
Will ther be any instances of H1 in between the specified ranges? If not, why not use:
=COUNTIF('Panel Draw'!B11:T223,"H1"), or even:
=COUNTIF('Panel Draw'!B:T,"H1")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks