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

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)
>