I need a statemnt to identify sales during each month
 

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

I need a statemnt to identify sales during each month
 

=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

I need a statemnt to identify sales during each month
 

Hi,

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

"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

I need a statemnt to identify sales during each month
 

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)

--
Jacob


"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