SUMIF with 2 conditions

[T. Valko]

Ooops! I used the wrong sum range in the long formula:

...+(H7:H71>=1)>0),J7:J71)

Should be:

....+(H7:H71>=1)>0),AE7:AE71)

--
Biff
Microsoft Excel MVP

Is that then an OR operation like this

If I understand what you want to do, it is, but you need to do it like
this:

=SUMPRODUCT(--((A7:A71>=1)+(B7:B71>=1)+(C7:C71>=1)+(D771>=1)+(E7:E71>=1)+(F7:F71>=1)+(G7:G71>=1)+(H7:H71>=1)>0),J7:J71)

See if this does what you want:

=SUMPRODUCT(--(MMULT(--(A7:H71>=1),{1;1;1;1;1;1;1;1})>0),AE7:AE71)

 

[JEB]

YES! Wow, Biff! That's awesome!

Thank you soooo much!

Ooops! I used the wrong sum range in the long formula:

...+(H7:H71>=1)>0),J7:J71)

Should be:

....+(H7:H71>=1)>0),AE7:AE71)

 

[T. Valko]

You're welcome. Thanks for the feedback!