| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum over a date range
Row†“ / Column†’ O Z AC AL
3 03-Jan-09 10.00 10.00 10.00 4 04-May-09 20.00 20.00 20.00 5 07-Mar-09 30.00 30.00 30.00 6 07-Jul-09 40.00 40.00 40.00 7 03-Jun-08 50.00 50.00 50.00 8 01-Apr-09 60.00 60.00 60.00 I am trying to add columns Z+AC+AL if column O falls within a date range of 01-Apr-09 to 30-Jun-09. I am transferring it to another worksheet. My equation is: =SUMPRODUCT((--'[ADR Statistics - template.xls]Region'!$O$3:$O$8=--"01-Apr-09")--('[ADR Statistics - template.xls] Region!$O$3:$O$8<=--"30-Jun-09")*('[ADR Statistics - template.xls] Region!$Z$3:$Z$8+'[ADR Statistics - template.xls] Region!$AC$3:$AC$8+'[ADR Statistics - template.xls] Region!$AL$3:$AL$8)) but it is returning a different number than expected. Thanks, Lynn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum If range of dates date range, sum totals | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
