| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE
I am having three columns
DATE, DESC, AMOUNT I want sum the amount based on month of the date-column ( Not sorted). Thanks & Regards |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DATE
Hi,
Try this =SUMPRODUCT((MONTH(A2:A17)=1)*(B2:B17="Whatever")* (C2:C17)) Where the 1 is january so change to suit. Note that this could be a cell reference where you could put the month to sum. Mike "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 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
