How to extract data based on multiple criteria

I am in need of assistance with a sumproduct formula. The attached file has yellow highlighted cells K12-AB13 in the Monthly worksheet which is where I need the formula.

I need a formula that will sum the data on the Details worksheets columns AB-AE. The criteria is:
The Name field on both sheets needs to match.
The Cat field on both sheets needs to match.
The Type field on both sheets needs to match.
The date in col AG on the Details page: the first day of the month in that col needs to match the date across row 9 in the Monthly tab.

The formula for the Cap row in the monthly tab needs to sum col AB in the Details tab for the matching data.
The formula for the Exp row in the monthly tab needs to sum col AC-AE in the Details tab for the matching data.

Thanks.
sumproduct formula help.xlsx

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

You dont need SP. Your title should describe what your problem is, not what you think the answer might be

Maybe something like this title?

Anyway, like I said, you dont need SP.

K5=SUMIFS(Details!$AB$6:$AB$22,Details!$M$6:$M$22,$E12,Details!$O$6:$O$22,$G12,Details!$P$6:$P$22,$I12,Details!$AG$6:$AG$22,">="&K$9,Details!$AG$6:$AG$22,"<"&EDATE(K$9,1))
copied across.

For the Exp, I could modify that to cover those 3 columns, but it would become pretty complex, so, instead, I added a helper column in Details, to add those 3 columns (I used AI), with this copied down from AI6...
=SUM(AC6:AE6)
The formula for Exp, then becomes...
=SUMIFS(Details!$AI$6:$AI$22,Details!$M$6:$M$22,$E12,Details!$O$6:$O$22,$G12,Details!$P$6:$P$22,$I12,Details!$AG$6:$AG$22,">="&K$9,Details!$AG$6:$AG$22,"<"&EDATE(K$9,1))

I see you changed the title. For me it doesn't match the solution I'm looking for, but really all I care about is the solution and not the title, so it's fine

you are welcome

As for the formula, I don't need a formula in K5. I need the formulas in the yellow cells on rows 12-13

so put my suggestions there instead.

when I enter it into K13 and drag it over, I don't get anything for December.

maybe you did not enter it correctly? I get the exact same values as your manually entered answers

	P	Q	R	S	T	U	V	W
8	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14	Jan-15
9	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14	Jan-15
10	0	0	0	0	0	0	0	0
11
12	$ -	$ 3,250.08	$ 15,670.24	$ 7,778.88	$ 20,201.11	$ 3,241.20	$ -	$ -
13	$ 500.00	$ 2,600.00	$ -	$ 864.32	$ -	$ 300.00	$ 6,500.16	$ -