Thread: Indirect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
  
Posts: 468
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!
Reply With QuoteReply With Quote