Functions for multiple sheets

[C4MARO]

Hi,

I have excel workbook with more than 50 sheets, lets say exactly 50 sheets and every sheet has the same concept. On 51th sheet I want to create some sumarization and counting by functions. In first column I have names of lists and in second column I want to create for example =COUNTIF('Sheet1'!A4:A500;"**-***-***") for each row (each list). How should I adress on each sheet without writting its name by hand? Is it possible to create function by text string?

for example I am on 51th sheet and I want to do this:

A1 .... "Name of 1st sheet"
B1 .... =A1!C3

But of course this doesnt work. Is there any solution? Thanks.

[:) Sixthsense :)]

It will work in this way...

=INDIRECT("'"&A1&"'!C3")

[C4MARO]

It works perfect! Thank you man. You saved me a lot of time

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback