I have a simple SUMIF which totals a column of cells based on a matching name:
This is for training courses which have a 'Course Date' (Sheet1!E:E) date cell. Sheet2!B1:M1 contains a heading of Months.
I need the SUMIF to total the values in Sheet1!D:D but also, only if the course date matches the same month as the heading in Sheet2!B1:B12.
I hope this, and the attached example spreadsheet (Excel 2003), makes some sense! So far I've tried SUMPRODUCT, SUMIF's, IF's and AND's, INDEX and MATCH, and I'm sure I've almost been there, but I can't find the right combination!