COUNTIF ? with multiple conditions

  • Thread starter Thread starter GW
  • Start date Start date
G

GW

My table looks like this:

A B C
Blue Chair Plastic
Green Chair Plastic
Blue Table Wood
Blue Stool Plastic
Green Chair Wood

I want to create calculations of the number of
- Blue Plastic Chairs
- Blue Wooden Chairs
- Green Plastic Chairs
- Green Wooden Chairs
- Blue Plastic Tables
- Blue Wooden Tables

etc

Help. I am using Excel 2002.

All help hugely appreciated.

GW
 
=SUMPRODUCT(A1:A100="Blue")*(C1:C100="Plastic")*(B1:B100="Chair")

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
To count the blue plastic chairs
=sumproduct((rngA="Blue")*(rngB="chair")*(rngC="plastic"))
 
Back
Top