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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect function countif 11
Combine SUMPRODUCT with INDIRECT function 2
INDIRECT function 4
Named ranges are causing a #REF error 3
Problem with a Sumproduct formula 3
summing across worksheets conditionally and being able to copy for 4
Vlookup and return sheet name also 2
Indirect formula not working if I give custom name for Sheets 1

Back
Top