Sum with conditions

Bucket28

New Member
Joined
Sep 7, 2002
Messages
23
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.
 

Some videos you may like

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
Joined
May 19, 2002
Messages
8,458
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
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

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