I have dates in column W and data in both Column AC and AD. I'd like to count how many "A"s are in both AC and AD prior to Dec 11. I know I'm missing something but can someone take a look at this for me?
=COUNTIFS(Data!W2:W53651,"<171211",Data!AC2:AC53651,"A",+Data!AD2:AD53651,"A")