Using two conditions with a SUMIF function in Excel 2003
Solution 1:
Assumptions:
Dates are in column B
Rows are 5:29
historical list in a range name 'Historical'
Month to test is in a range name 'rngMonth'
=SUMPRODUCT((NOT(ISNA(MATCH(A5:A29,Historical,FALSE))))*(MONTH(B5:B29)=rngMonth)*(C5:C29))Solution 2:
Try to add another SUMIF function which excludes those cells which you don't want to be SUMMed up & remove it from the main SUMIF.
e.g. SUMIF(all cells which fits large criteria) - SUMIF(all cells which are part of small criteria).