View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default SumIf - More then 1 criteria - Please assist

Nope. You want sumproduct to do that. Check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Nir" wrote:

Hi,
How can i use sumif formula with more then ONE criteria?