| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Can SUMIF function include AND function | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Hybrid Mode
