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?