Hi Gizmo,
Certainly don't want to discourage thanking responders in a
thread or in email, but it is best not to change the subject,

It is hard to follow a thread in Google Groups when the subject
changes. It also tends to confuse -- is it the same thread or not.

And it is important in some threads to indicate which solution was
tried/worked in those that have conflicting suggestions, a change
of subject may make the thank you look like it applies to something else.

Most of the people answering will see replies to their answers,
usually in RED and by using Outlook Express. Without the quoted
material you included, one might have to switch to viewing all
messages just to tell which question was being responded to as
many responders answer more than one question in day though
there are few days that anyone surpasses Frank in number of
responses.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Gizmo" wrote ...
Thanks guys for your valuable comments!
Now I see much clearer...

"Frank Kabel" wrote in message
try
=COUNTIF(INDIRECT("'" & B1 &"'!B6:BK6"),C1)
B1: country name
C1: date value