Count multiple criteria

[G2K]

Hi all,

here is the sample data, on which i want to count the record based of specefic criteria

Cname Product Model Mfg Year
ABC PQR MNO 2003
ABC STU MNO 2004
XYZ PQR MNO 2005
XYZ STU MNO 2006
ABC STU IJK 2007
XYZ PQR IJK 2008
ABC PQR IJK 2009
XYZ PQR IJK 2010
ABC PQR IJK 2011
XYZ STU IJK 2012


Count of records where Cname = ABC,Product = PQR,Model = IJK and Mfg Year is > 2005

[DonkeyOte]

Traditional solution pre XL2007 would be SUMPRODUCT, eg:

=SUMPRODUCT(--($A$1:$A$100="ABC"),--($B$1:$B$100="PQR"),--($C$1:$C$100="IJK"),--($D$1:$D$100>2005))