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
|