Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel sales figures
I have a real dates in column A from 01-Jan-2007 till 31-Dec-2007
and in B column I have Sales figures for each date I need formula to give me total sales figures for June only or July only your help is highly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel sales figures
Have you tried a pivot table. Select Data - Pivot Table and follow the
wizard. Place the dates in the left hand column and the sales in the data area. Right click on the dates in the pivot table and select Group. Assuming you have all dates with no blanks then it should have an option of Days, Months, Quarters, years. Select the ones you want. Everything is now grouped. There is more stuff you can do including formatting and such... -- HTH... Jim Thomlinson "George A. Jululian" wrote: I have a real dates in column A from 01-Jan-2007 till 31-Dec-2007 and in B column I have Sales figures for each date I need formula to give me total sales figures for June only or July only your help is highly appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel sales figures
Hi,
Try this: =SUMPRODUCT(--(MONTH(A1:A365)=C1),--(A1:A3650),B1:B365) put the month number in C1, adjust to suit! HTH Jean-Guy "George A. Jululian" wrote: I have a real dates in column A from 01-Jan-2007 till 31-Dec-2007 and in B column I have Sales figures for each date I need formula to give me total sales figures for June only or July only your help is highly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOw do I merge two separate months of sales figures? | Excel Worksheet Functions | |||
Trying to find sales figures of certain products€¦ | Excel Worksheet Functions | |||
create a top 10 list of sales figures | Excel Worksheet Functions | |||
Splitting apart Name from Sales figures | Excel Discussion (Misc queries) | |||
Need help producing simple sales figures | Excel Discussion (Misc queries) |