Indirect
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!
|