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