Autofill updating sheets

  • Thread starter Thread starter moneyline
  • Start date Start date
M

moneyline

Hi,
I have a COUNTif formula counting "0" in 1 coloumn of each sheet. I
150 sheets is the total sheet, in which I want to be able to autofil
and have the formula update. Example:

=COUNTIF('09-01'!O:O,"0")
=COUNTIF('09-02'!O:O,"0")
=COUNTIF('09-03'!O:O,"0")

How do I drag it so that the formula in the next row will import fro
the next sheet.

Best Forum ever....

Luk
 
Hi
try something like
=COUNTIF(INDIRECT("'09-" & TEXT(ROW(1:1),"00") & "'!O:O"),"0")
 
Back
Top