I need a statemnt to identify sales during each month

[Wanda Blankenstein]

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

 

[Gary''s Student]

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

This formula assumes that the data in column C is a text value for each month.

 

[Eduardo]

Hi,

=SUMPRODUCT((C1:C15="Oct")*E1:E15)

 

[Jacob Skaria]

With dates in excel date format in Col C formatted to display as month;try
the below to sum ColE for Oct in ColC

=SUMPRODUCT((TEXT(C1:C15,"mmmyyyy")="Oct2009")*E1:E15)