Indirect

  • Thread starter Thread starter puiuluipui
  • Start date Start date
P

puiuluipui

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!
 
Hi, i have read earlier post, but i have one last problem. I replied to
earlier post.
Thanks allot!

muddan madhu said:
check your earlier post


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!
Click to expand...

.
Click to expand...
 
Back
Top