Hi all,
The following formula works as intended:
SUM(COUNTIFS(Data!$O:$O,">="&Leaderboard!I$202,Data!$O:$O,"<"&Leaderboard!J$202,Data!$DH:$DH,Leaderboard!$B203,Data!$HG:$HG,{"<>-","-","<>-"},Data!$HD:$HD,{"Q4 2018 Campaign","Q4 2018 Campaign",""}))
However, I read that having more than two or statements inside the countifs() statement, will cause the wrong results, ie. I shouldn't do this:
SUM(COUNTIFS(Data!$O:$O,">="&Leaderboard!I$202,Data!$O:$O,"<"&Leaderboard!J$202,Data!$DH:$DH,Leaderboard!$B203,Data!$HG:$HG,{"<>-","-","<>-"},Data!$HD:$HD,{"Q4 2018 Campaign","Q4 2018 Campaign",""},Data!$HE:$HE,{">Data!$HF:$HF";""}))
How can I write such countifs() formula with 3+ or statements?
Bookmarks