SUMIF FUNCTION

[Guest]

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.54900.FMS",53000.5300200010.00300.206004.20060.54901.FMS",'06-07 IT Exp. Pd. in 07-08'!B4:B100).

 

[Bob Phillips]

=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.54901.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.54900.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.54901.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)

 

[Guest]

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

=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.54901.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.54900.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.54901.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)

 

[Guest]

My mistake, the SUMPRODUCT FORMULA works.


--
Thank you for your help
MO
Albany, NY

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.