| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A follow up Question
I have now tried to incorporate the "BOMONTH" formula into the larger
formula below but I am getting #VALUE. =SUMPRODUCT((dciValueDate<=+$L$64)*(dciValueDate= (EOMONTH($L$64,-1)+1))*(dc iGBPAmount)) The formula is attempting to sum the amounts in the range dciGBPAmount where the date in the column dciValueDate is in March 2008. L64 contains the date 31st March 2008. Any ideas what is wrong with the syntax? Cheers, Andrew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Follow-up AVERAGEIF question | New Users to Excel | |||
| Follow-up Question for Dave Peterson | Excel Discussion (Misc queries) | |||
| Follow-up to Logical Test Question | Excel Worksheet Functions | |||
| follow-up question regarding secondary Y-axes | Charts and Charting in Excel | |||
| Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
Threaded Mode
