I need a statemnt to identify sales during each month

  • Thread starter Thread starter Wanda Blankenstein
  • Start date Start date
W

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
 
=SUMPRODUCT((C1:C17="oct")*(E1:E17))

This formula assumes that the data in column C is a text value for 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)
 
Back
Top