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