Thread: SUMIFS and OR
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default SUMIFS and OR

SumProduct perhaps???

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
It looks like this web page might be temporarily down. Not too sure...
--
HTH...

Jim Thomlinson


"mohavv" wrote:

Hi,

Is there a way to use the OR function within the SUMIFS function, if
you only want to sum two criteria-values (not consecutive).

Cheers,

Harold