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

I am not having any luck.


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, 2016 at 23:28

1 Answer 1


I eventually used:

  • 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, 2016 at 20:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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