Sum with conditions

[Bucket28]

Book2.xls
	A	B	C	D	E	F	G
1	June
2	July
3	August
4	Date		Vendor	Description	Account Number	Office	Amount
5	7	- 29	A			1	$ 196.85
6	8	- 2	B			2	$ 3.77
7	8	- 3	A			2	$ 3.99
8	8	- 4	A			1	$ 17.95
9	8	- 9	B			1	$ 19.00
10	8	- 12	B			3	$ 180.00
Sheet1

I need a formula that will give me the total spent in each month based on the office. So at the top of the sheet by the month. I want two total columns based on the month.

I hope this makes sense. Its harder to describe than I thought.

Thanks for the help.

 

[texasalynn]

could you please redo you sample I can't tell what you have going on. Read the FAQ about posting HTML to get read of NBSP

 

[Andrew Poulsom]

Book11
	A	B	C	D	E	F	G
1		1	2	3
2	June	$0.00	$0.00	$0.00
3	July	$196.85	$0.00	$0.00
4	August	$36.95	$7.76	$180.00
5	Date		Vendor	Description	AccountNumber	Office	Amount
6	7	-29	A			1	$196.85
7	8	-2	B			2	$3.77
8	8	-3	A			2	$3.99
9	8	-4	A			1	$17.95
10	8	-9	B			1	$19.00
11	8	-12	B			3	$180.00
Sheet1

The formula in B2 is:

=SUMPRODUCT(--($A$6:$A$11=MONTH(DATEVALUE($A2&"-2005"))),--($F$6:$F$11=B$1),($G$6:$G$11))

copied down and across.

 

[Bucket28]

Thanks that is perfect