Thread: Indirect
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default Indirect

Hi, i have read earlier post, but i have one last problem. I replied to
earlier post.
Thanks allot!

"muddan madhu" wrote:

check your earlier post


On Nov 14, 10:18 pm, puiuluipui
wrote:
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!


.