| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
