Hi,
The formula I have found for what I want to do is below, but there may be an easier/better one:
=COUNTIFS(Data!$C:$C,Lists!D1:D2,Data!$F:$F,Lists!$C$1,Data!$G:$G,Lists!A1)
In column C of the Data tab, this is a drop down list of about five options. I want it to count how many times two of those options appear, if column F matches what is listed in C1 on the Lists tab, and column G matches A1 on the lists tab. The two fields I want it to search for are D1 and D2 on the Lists tab.
In the above, it will only count D2. I have tred a number of variations but I can't get it to work correctly Any ideas??
Bookmarks