=SUMPRODUCT((C1:C17="oct")*(E1:E17))

This formula assumes that the data in column C is a text value for each month.
--
Gary''s Student - gsnu200909


"Wanda Blankenstein" wrote:

I have a consignment booth that i list inventoy. I need to only add those
items sold in a given month.

Item month sold $ sold % to consgnee

things oct 4.00 .40
things oct 2.00 .40
things nov 3.00 .40
stuff dec 4.00 .40
Total ______ ___

I have tried =IF(C1:c15)=oct,SUM(E1:E17)) I don't think I'm even close
--
Gertrude