Can I use more complex logical expression for sumif as creteria?

That complicates matters some. We have to sum the rows in which either
criterion is met and subtract the rows where both are met (otherwise
the latter cases would be counted twice). Either of these work:

=SUMPRODUCT(--(A3:A10="MA"),F3:F10)+SUMPRODUCT(--(B3:B10>5000),F3:F10)-SUMPRODUCT(--(A3:A10="MA"),--(B3:B10>5000),F3:F10)

=SUMIF(A3:A10,"MA",F3:F10)+SUMIF(B3:B10,">5000",F3:F10)-SUMPRODUCT(--(A3:A10="MA"),--(B3:B10>5000),F3:F10)

This is a bit shorter:

=SUMPRODUCT(--((A3:A10="MA")+(B3:B10>5000)>0),F3:F10)


In article <1146163561.677247.234460@u72g2000cwu.googlegroups.com>,
"Mark Lincoln" <mlincoln@earthlink.net> wrote:

> That complicates matters some. We have to sum the rows in which either
> criterion is met and subtract the rows where both are met (otherwise
> the latter cases would be counted twice). Either of these work:
>
> =SUMPRODUCT(--(A3:A10="MA"),F3:F10)+SUMPRODUCT(--(B3:B10>5000),F3:F10)-SUMPROD
> UCT(--(A3:A10="MA"),--(B3:B10>5000),F3:F10)
>
> =SUMIF(A3:A10,"MA",F3:F10)+SUMIF(B3:B10,">5000",F3:F10)-SUMPRODUCT(--(A3:A10="
> MA"),--(B3:B10>5000),F3:F10)

Oops, didn't see the identical solution in the other subthread...

In article <jemcgimpsey-5E3D43.17503727042006@msnews.microsoft.com>,
JE McGimpsey <jemcgimpsey@mvps.org> wrote:

> This is a bit shorter:
>
> =SUMPRODUCT(--((A3:A10="MA")+(B3:B10>5000)>0),F3:F10)
>