Excel: COUNT IF Column >= Another Column AND Equals x-CodePudding

I am trying to create a formula in Excel where multiple conditions are met.

I would like to create a statement where is says (apologies for the rudimentary example):

Count if Column A contains "Ball", Column B contains "Cat", and Column C's Date is >= Column D's Date

CodePudding user response：

Use SUMPRODUCT and limit the ranges to the dataset

=SUMPRODUCT((A1:A10="Ball")*(B1:B10="Cat")*(C1:C10>=D1:D10))

CodePudding user response：

Do you want it to be counted, or do you need a column to tell you whether the info is correct or not?