Use the indirect function.
--
David Biddulph

"iksuinje" wrote in message
...
Hi,

I am doing data processing without using macro...because data formats are
so
random.

My qustion is about how to insert same row numbers in the several function
statement even though the colums are different. My function statements are
as
follows. They are all used in one sheet.
IF(E3="","",COUNTIF(D$3:D$306,LEFT(D3,FIND("/",D3)-1)&"*"))
IF(E3="","",COUNTIF('[example.xls]variables to 2004'!$E$3:$N$306,E3&"/*"))
IF(E3="","",COUNTIF('[example.xls]variables to 2004'!$E$3:$L$306,E3&"/*"))
IF(E3="","",COUNTIF('[example.xls]variables to 2004'!$E$3:$J$306,E3&"/*"))
IF(L3="","",COUNTIF(K$3:K$306,LEFT(K3,FIND("/",K3)-1)&"*"))
IF(L3="","",COUNTIF('[example.xls]variables to 2004'!$G$3:$P$306,L3&"/*"))
IF(L3="","",COUNTIF('[example.xls]variables to 2004'!$G$3:$N$306,L3&"/*"))
.
.
.

As you see the same row numbers "3" and "306" are frequently used. So is
there any way to simply insert this numbers only once then let it
automatically inserted at several function statements.

thank you in advance for help