| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! with long function
I need to write a function with the following parameters for a work
spreadsheet. If A:4:A29 is between the dates 07/01/2007 and 07/31/2007, add cells D4:D29 for those dates. Can anyone help, please, please? -- Spoe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP! with long function
=SUMPRODUCT(--(MONTH(A4:A29)=7), D4:D29)
For more details on SUMPRODUCT http://www.xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "spoe" wrote in message ... I need to write a function with the following parameters for a work spreadsheet. If A:4:A29 is between the dates 07/01/2007 and 07/31/2007, add cells D4:D29 for those dates. Can anyone help, please, please? -- Spoe |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP! with long function
=SUMPRODUCT(--(MONTH(A4:A29)=7),--(YEAR(A4:A29)=2007),D4:D29)
"spoe" wrote: I need to write a function with the following parameters for a work spreadsheet. If A:4:A29 is between the dates 07/01/2007 and 07/31/2007, add cells D4:D29 for those dates. Can anyone help, please, please? -- Spoe |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP! with long function
Good point, I forgot to check year (data could be multi-years)
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Teethless mama" wrote in message ... =SUMPRODUCT(--(MONTH(A4:A29)=7),--(YEAR(A4:A29)=2007),D4:D29) "spoe" wrote: I need to write a function with the following parameters for a work spreadsheet. If A:4:A29 is between the dates 07/01/2007 and 07/31/2007, add cells D4:D29 for those dates. Can anyone help, please, please? -- Spoe |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP! with long function
Take your pick:
=SUMIF(A4:A29,"="&DATE(2007,7,1),D4:D29)-SUMIF(A4:A29,""&DATE(2007,7,31),D4:D29) A1 = 7/1/2007 B1 = 7/31/2007 =SUMIF(A4:A29,"="&A1,D4:D29)-SUMIF(A4:A29,""&B1,D4:D29) =SUMPRODUCT(--(TEXT(A4:A29,"m/yyyy")="7/2007"),D4:D29) -- Biff Microsoft Excel MVP "spoe" wrote in message ... I need to write a function with the following parameters for a work spreadsheet. If A:4:A29 is between the dates 07/01/2007 and 07/31/2007, add cells D4:D29 for those dates. Can anyone help, please, please? -- Spoe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| Long Logical function | Excel Worksheet Functions | |||
| Does Excel 2003 have a function to calculate how long money will l | Excel Worksheet Functions | |||
| Long Date - Long Date = text is days | Excel Discussion (Misc queries) | |||
| How long until 5:00? | Excel Discussion (Misc queries) | |||
Linear Mode
