| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trailing 3 month sales | Excel Worksheet Functions | |||
| projecting sales for month | New Users to Excel | |||
| Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
| Identify month in a period and run a formula | Excel Discussion (Misc queries) | |||
Linear Mode
