Count if two criteria match – EXCEL formula August 30, 2023 by Tarik Add the sheet name infront of the cell, e.g.: =COUNTIFS(stock!A:A,"M",stock!C:C,"Yes") Assumes the sheet name is “stock”