My mistake, the SUMPRODUCT FORMULA works.


--
Thank you for your help
MO
Albany, NY


"MO" wrote:

Bob,

When I use the first formula, I get VALUE. When I use the second, I get
REF. I believe I'm getting VALUE because I'm using " ". But if I take the "
"out, it I get the formula you typed contains and error.
--
Thank you for your help
MO
Albany, NY


"Bob Phillips" wrote:

=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