Hi
try
=COUNTIF(INDIRECT("'" & B1 &"'!B6:BK6"),C1)
B1: country name
C1: date value

--
Regards
Frank Kabel
Frankfurt, Germany
"Gizmo" schrieb im Newsbeitrag
...
Hi guys,

I start with a simple COUNTIF formula that is like this:

=COUNTIF(Germany!$B$6:$BK$6,"22.12.2004")

Then, I would like to make it more flexible, as there can be multiple
worksheets and multiple dates to request. The parts that I would like to
refer to indirectly would be country's name (f. ex. "Germany") and the
specific date (f. ex. 22.12.2004). The formula would be implemented on the
worksheet named "Totals".

Intuitively, I thought that the new formula should be more or less like
the
one just below, but for some reason it's not working...

=COUNTIF(INDIRECT(B1&"!$B$6:$BK$6,Totals!"&A2))

(FYI: In the cell B1 I would put worksheets' name (f. ex. Germany) and in
A2
would put the date I'm interested in (f. ex. 22.12.2004))

Any idea what I'm doing wrong?
Thanks for your help!

Gizmo