I am trying to sum entries in a column if the data in previous columns matche different criteria..

Ex in column "B" items are either reb, blue, green or black...etc

in column "C" items are round, square, triangular ...etc

In column "H" have a quantity (Number) for each item listed.

I need to work out how many red squares there are

so: if I want to know how many red squares are in stock I want to SUM IF items listed as red in column "B" AND "Square" in column "C" from quantities in Column "H"

It must be some combination of

**SUM**of quantities in column "H", only

**IF**"B5: B100" =Red &

**AND**"C5:C100= "Square"

I have been going round in circles for some time...Any help would be welcome..

Cheers,

Chuck D