Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 2, 2024
Count Based on Multiple Criteria
The following formula counts the number of times a value in B3:B12 equals the value in E3, and the corresponding value in C3:C12 equals the value in F3...
=COUNTIFS(B3:B12,E3,C3:C12,F3)
For earlier versions of Excel...
=SUMPRODUCT(--(B3:B12=E3),--(C3:C12=F3))
Based on the sample data, the formula returns 2.
Sample Workbook: Download