| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could anybody tell me how to add values based on dates.
I want to get the sum of a particular month E.G. 1 Jan 07 to 31 Jan 07 from 6
months data? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Could anybody tell me how to add values based on dates.
Assuming there is only January for ONE year then try:
=SUMPRODUCT(--(MONTH(A1:A100)=1)*(B1:B100)) Where A1:A100 are your dates (cells formatted as DATE) and B1:B100 is the data to be summated. If there are multiple years: =SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2007)*(B1:B100)) HTH "Muhammad Nazim uddin" wrote: I want to get the sum of a particular month E.G. 1 Jan 07 to 31 Jan 07 from 6 months data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| line graph-need to pick up dates as values for the x axis? | Charts and Charting in Excel | |||
| How to dates column with values in next column | Excel Discussion (Misc queries) | |||
| FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
| If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions | |||
Linear Mode
