Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT, INDIRECT, dates...
Hi,
I recently asked for help looking up values in one column by the year in another column on different worksheets, and was very kindly given the following solution: =SUMPRODUCT(--(YEAR(INDIRECT("'"&A3&"'!H8:H1000"))=2008),INDIREC T("'"&A3&"'!I8:I1000")) I have now been asked to add sub-totals by month! I came up with: =SUMPRODUCT(AND(--(YEAR(INDIRECT("'"&A3&"'!H8:H1000"))=2008),(--(MONTH(INDIRECT("'"&A3&"'!H8:H1000"))=1))),INDIREC T("'"&A3&"'!I8:I1000")) however this returns a #VALUE! error. I have also tried JANUARY instead of 1 for the month criteria - same result. If anyone could help me on this I would be very grateful. TIA. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct with indirect | Excel Worksheet Functions | |||
SUMPRODUCT & INDIRECT? | Excel Worksheet Functions | |||
Need help with using SUMPRODUCT with INDIRECT | Excel Worksheet Functions | |||
Help with Sumproduct with Indirect | Excel Worksheet Functions | |||
sumproduct & indirect | Excel Worksheet Functions |