=SUMPRODUCT(--(ISNUMBER(MATCH('06-07 IT Exp. Pd. in
07-08'!E4:E100,{"53000.5300200010.00300.206004.20060. 54900.FMS",53000.5300200010.00300.206004.20060.549 01.FMS"},0))),'06-07
IT Exp. Pd. in 07-08'!B4:B100)

or

=SUMIF('06-07 IT Exp. Pd. in
07-08'!E4:E100,"53000.5300200010.00300.206004.20060.5 4900.FMS",'06-07 IT
Exp. Pd. in 07-08'!B4:B100)+
SUMIF('06-07 IT Exp. Pd. in
07-08'!E4:E100,"53000.5300200010.00300.206004.20060.5 4901.FMS",'06-07 IT
Exp. Pd. in 07-08'!B4:B100)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MO" wrote in message
...
I'm trying to accomplish adding figures that meet TWO criteria. When I
use
the SUMIF FUNCTION, it only allows me to search for one criteria. Below is
what I'm looking to find. I keep getting an error.


=SUMIF('06-07 IT Exp. Pd. in
07-08'!E4:E100,"53000.5300200010.00300.206004.20060.5 4900.FMS",53000.5300200010.00300.206004.20060.5490 1.FMS",'06-07
IT Exp. Pd. in 07-08'!B4:B100).
--
Thank you for your help
MO
Albany, NY