# Sum with conditions

#### Bucket28

##### New Member
Book2.xls
ABCDEFG
1June
2July
3August
4DateVendorDescriptionAccount NumberOfficeAmount
57- 29A1\$ 196.85
68- 2B2\$ 3.77
78- 3A2\$ 3.99
88- 4A1\$ 17.95
98- 9B1\$ 19.00
108- 12B3\$ 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.

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

#### texasalynn

##### Well-known Member
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

##### MrExcel MVP
Book11
ABCDEFG
1123
2June\$0.00\$0.00\$0.00
3July\$196.85\$0.00\$0.00
4August\$36.95\$7.76\$180.00
5DateVendorDescriptionAccountNumberOfficeAmount
67-29A1\$196.85
78-2B2\$3.77
88-3A2\$3.99
98-4A1\$17.95
108-9B1\$19.00
118-12B3\$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

##### New Member
Thanks that is perfect

Replies
2
Views
72
Replies
9
Views
228
Replies
1
Views
187
Replies
5
Views
57
Replies
1
Views
57

1,118,117
Messages
5,570,278
Members
412,316
Latest member
JabirS