Hello,
I am new to VBA but I think this is possible. I have two drop-down lists that contain text and are named (A2=USID and B2=Program). What I need is to have a COUNTIF equation calculated based on the selection in the two drop down boxes. For instance, IF USID = RMR-Other AND Program = LTE then calculate the following:
Result in cell G3: COUNTIFS(F_MS30,"<="&G$2,A_MS30,"",USID_Range,"=RMR-Other",Program_Range,"=LTE")
Result in cells H3:BV3: COUNTIFS(F_MS30,"<="&H$2,F_MS30,">"&G$2,A_MS30,"",USID_Range,"=RMR-Other",Program_Range,"=LTE")
-Where G2 = a date, not named
-Where H2:BV2 = dates, not named
-Where F_MS30 = a named range of dates
-Where A_MS30 = a named range of dates
-Where USID_Range = a named range of text
-Where Program_Range = a named range of text
I just need to be shown a few iterations of the code and I can catch on and complete the rest.
Thanks in advance.
Bookmarks