View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default SUMIFS using an "Or" condition?

Excel 2007
Method #1 SUMIFS()
Method #2 Sumproduct (DeMorgan's Logic)
Method #3 Advanced Filter
http://www.mediafire.com/file/gjywmqn4nw4/07_13_09.xlsx