Gathering amounts based on date for a monthly average

[avidcat]

I have a series of employee variances and dates for the variances in two columns.

I have another section on the same sheet where I want to track the amount of variances & occurances for certain months.

attached is an example of what I am looking to do.

I appreciate any help.

Nick

[DonkeyOte]

Given use of XL2007

E3: =COUNTIFS($A$3:$A$32,">="&$D3,$A$3:$A$32,"<"&EDATE($D3,1))
copied down

F3: =SUMIFS($B$3:$B$32,$A$3:$A$32,">="&$D3,$A$3:$A$32,"<"&EDATE($D3,1))
copied down

Note - neither of the above are backwards compatible with earlier versions - for earlier versions either use SUMPRODUCT or use a helper column to normalise date and revert to COUNTIF, SUMIF based around normalised date field.

EDIT:
just to add, I'm assuming you don't want to display all months - if you do you should just use a Pivot Table.

[avidcat]

Thanks, worked perfect.