View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How can I use OR function inside SUMIFS

Hi,
Please post your formula and indicate where you need the or, thanks
However you will need to use an if statement

=if(or(A1=0,B1=3),sumifs(...............

"Baybora" wrote:

I asked thsi question last week and thanks Luke M for his kind interest.

However it did not solve my problem
for example I'm writing
SUMIFS(long and 4-5 ciriterias).
But in one cirteria I need to say "OR"
A long way is I write
SUMIFS(...................................)+SUMIFS (.....................).
I cant imagine if my need will be 3-4 ORs : )
Best wishes,
Baybora