=COUNTIFS('Exe Checker Dump'!O:O,Sheet3!B3,'Exe Checker Dump'!X:X,"DEB",'Exe Checker Dump'!Y:Y,"DEB",'Exe Checker Dump'!A:A,Sheet3!A4)
and
=COUNTIFS('Exe Checker Dump'!O:O,Sheet3!B3,'Exe Checker Dump'!X:X,"DEB",'Exe Checker Dump'!Y:Y,"DEN",'Exe Checker Dump'!A:A,Sheet3!A4)
i want to a common answer of these two countifs.
for example if the answer to the 1st countifs is 10 and the second is 30, i need a formula that would combine both of them and give me an answer as 40
Bookmarks