View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default I need alternative formula for SUMIFS in Excel 2003

The 2003 version of SUMIFS is SUMPRODUCT.

Scan the archives or post back if you need more information.

Regards,
Fred.

"Jerome" <sheltyatfusedotnet wrote in message
...
I am using the SUMIFS formula in Excel 2007, but Excel 2003 doesn't
recognize this and I need to send the file to people using Excel 2003. I
tried to use SUMIF, but I have 3 criteria to search for.
Does anybody know of a similar formula that works for Excel 2003?

Thanks!