| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE
=SUMPRODUCT(--(month(a2:a100)=7),c2:c100)
will sum month of July (all years) =SUMPRODUCT(--(month(a2:a100)=7),--(Year(a2:a100)=2007),c2:c100) July 2007 It's better to put your comparator values in cells: =SUMPRODUCT(--(month(a2:a100)=X1),--(Year(a2:a100)=X2),c2:c100) X1=7, X2=2007 HTH "Jamal A M" wrote: I am having three columns DATE, DESC, AMOUNT I want sum the amount based on month of the date-column ( Not sorted). Thanks & Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
