|
SUMIF FUNCTION
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 |
SUMIF FUNCTION
=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 |
SUMIF FUNCTION
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 |
SUMIF FUNCTION
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 |
| All times are GMT +1. The time now is 04:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com