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

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)

"taisn" <[email protected]> wrote in message
news:[email protected]...
> 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?

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???

"Bob Phillips" wrote:

> =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)
>
> "taisn" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>