ExcelBanter - Indirect

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Indirect (https://www.excelbanter.com/excel-discussion-misc-queries/248454-indirect.html)

puiuluipui

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!

muddan madhu

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!

puiuluipui

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!

.

All times are GMT +1. The time now is 06:33 AM.