0

I have read through a few of these on here and they are saying to use indirect():

I am not having any luck.

=COUNTIF(JAN!$C$4:$C$102,B5) 

This formula works but when I try to get D2 in there for JAN or FEB, I can't get it to work.

=COUNTIF(INDIRECT('D2' & "!" & $C$4:$C$102),B5)

D2 is a drop down data validation select from items to select JAN.,

How do I get D2 to equal JAN in the formula so it works with selecting the drop down selection?

  • Instead of 'D2' use D2, and instead of "!" & $C$4:$C$102 use "!$C$4:$C$102" – Rubén Aug 25 '16 at 23:28
-1

I eventually used:

=COUNTIF(indirect(D2&"!$C$4:$C$102"),B5)
  • If you want to merge your unregistered account into your new one so you'll regain access to the question use the contact us form. – ChrisF Aug 26 '16 at 20:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.