Excel 2007 SUMIFS formula to be use in Excel 2003
 

I have a formula for SUMIFS in Excel 2007,
ˆ‘Component_Amt/1000 if Reg_Component_Type = €˜INV_INK
Less
ˆ‘Component_Amt/1000 if Reg_Component_Type = €˜INV_EXP

but i need it to be function in excel 2003. So how should i write the formula?
thank you.

Excel 2007 SUMIFS formula to be use in Excel 2003
 

Maybe...

=(sumif(reg_component_type,"inv_ink",component_amt )
-sumif(reg_component_type,"inv_exp",component_amt))/1000

If that doesn't work, you may want to post your current =sumifs() formula.






izzy wrote:

I have a formula for SUMIFS in Excel 2007,
ˆ‘Component_Amt/1000 if Reg_Component_Type = €˜INV_INK
Less
ˆ‘Component_Amt/1000 if Reg_Component_Type = €˜INV_EXP

but i need it to be function in excel 2003. So how should i write the formula?
thank you.

--

Dave Peterson