Thread: Excel 2007 SUMIFS formula to be use in Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Izzy Izzy is offline
external usenet poster
  
Posts: 8
Default 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.
Reply With QuoteReply With Quote