Combining Sumifs Help Please

[Mathman]

Hi


Is their a way to rewrite these 2 sumifs (array) into 1 so that I would have 4 conditions?


=SUM(IF(($H$2:$H$2634<$N3)*($H$2:$H$2634>=N4),$G$2:$G$2634,""))


=SUM(IF(($A$2:$A$2634<$O3)*($A$2:$A$2634>=O4),$G$2:$G$2634,""))


Thank you!
MM​

 

[James006]

Hi,

With Array Formulas, you can use :

The + (plus) sign to get OR

The * (multiplication) sign to get AND

Hope this will help

 

[Mathman]

can't seem to get it working......

 

[James006]

Well ...

Difficult for me to guess what is your underlying logic ... i.e. your choice between : OR - AND ...

Just test the following Combined Array Formulas:

A. YourFormula1 + YourFormula2

B. YourFormula1 * YourFormula2

Most probably, given your expected result ... you will be able to determine which Formula is the one you needed ...

HTH

 

[Aladin Akyurek]

Hi


Is their a way to rewrite these 2 sumifs (array) into 1 so that I would have 4 conditions?


=SUM(IF(($H$2:$H$2634<$N3)*($H$2:$H$2634>=N4),$G$2:$G$2634,""))


=SUM(IF(($A$2:$A$2634<$O3)*($A$2:$A$2634>=O4),$G$2:$G$2634,""))


Thank you!
MM​

Control+shift+enter, not just enter:

=SUM(IF(($A$2:$A$2634<$O3)*($A$2:$A$2634>=O4)*($H$2:$H$2634<$N3)*($H$2:$H$2634>=N4),$G$2:$G$2634))

Is this what you are after?

 

[Mathman]

I might have got it to work, will let you know once I run some more tests.

Thank you!