SumIFS() filtered by the month of a date cell

Hi truecrisis,
I would use the DSUM function

For the function as you have it abouve you don't need SUMIFS. It is only one criteria so just SUMIF will suffice, written as: =SUMIF('1.Daily'!B:B,DATE(E3,C3,D3),'1.Daily'!C:C)

For extracting the month or year only, you will either need a helper column to first extract the month or year using the MONTH() or YEAR() functions..

or you can use SUMPRODUCT()

e.g.


=SUMPRODUCT(--(MONTH('1.Daily'!B:B)=12),'1.Daily'!C:C)

or


=SUMPRODUCT(--(YEAR('1.Daily'!B:B)=2010),'1.Daily'!C:C)

where you can obviously replace the 12 or 2010 with a cell reference.

NOTE though: When using SUMPRODUCT it is more adviseable to use limited ranges instead of whole column references...

If you must have whole column references, it would be adviseable to use the helper column method and then SUMIF() against that column.