Is there a way to sum a column using criteria from multiple column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure how to ask this,
I am currently working on a spreadsheet that has an itemized worksheet
depicting each budget approval (Sheet2). I have it tied into our complete
budget so that it automatically adds and/or subtracts the amounts according
to the date...

=SUMIF('Sheet2'!$K:$K,"="&(TEXT(D$5,"mmm-yy")),'Sheet2'!$E:$E)

....but I also need it to be specific to the "BUD#" and "LINE#" (see below).

SHEET2
A B C D E
BUD # LINE # CAF Date Constructed Key Field Dollar Amount
AUBUD 01 12/9/05 =TEXT(C1,"mmm-yy") $13,600.00
AUBUD 01 3/6/06 =TEXT(C2,"mmm-yy") 19,000.00
AUBUD 03 12/9/05 =TEXT(C3,"mmm-yy") $88,810.00
AUBUD 05 12/9/05 =TEXT(C4,"mmm-yy") $23,113.00
CPBUD 06 12/12/05 =TEXT(C5,"mmm-yy") $9,400.00
BLBUD 01 12/12/05 =TEXT(C6,"mmm-yy") $62,234.00
CPBUD 01 12/12/05 =TEXT(C7,"mmm-yy") $5,750.00

Is there a way to do this with multiple criteria?
 
=SUMPRODUCT(--('Sheet2'!$K2:$K200=TEXT(D$5,"mmm-yy")),--('Sheet2'!$A2:$A200=
"AUBUD"),--('Sheet2'!$B2:$B200="01"),'Sheet2'!$E2:$E200)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thank you for such a quick response... I've been trying your suggestion all
day and for whatever reason, I can't seem to get anything to calculate, but
at least I'm not getting error messages anymore :P
I think I've been staring at the "same thing" for too long, so I will try
again tomorrow and see if I can get anything to work???
 
Back
Top