Thread: Indirect
View Single Post
  #1  
Old November 14th, 2009, 05:18 PM posted to microsoft.public.excel.misc
puiuluipui
external usenet poster
  
Posts: 467
Default Indirect
Hi, can this code be made to work with more than one sheet?

=IF(SUMPRODUCT(COUNTIF(INDIRECT("["&N1&"]"&"LUNI!$C:$C"),C5))0,"YES","NO")

-sheets : LUNI ; MARTI ; MIERCURI ; JOI ; VINERI

Can this be done?
Thanks!