Thread: SUMIFS and OR
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default SUMIFS and OR
The same format applies.
Just OR the same column two (or more) times.
=SUM(AA)-SUMIFS(AA,BB,"<B",BB,"<E") =404
=SUMPRODUCT(AA*NOT(NOT(BB="B")*NOT(BB="E"))) =404


Reply With QuoteReply With Quote