Try this:

=SUMPRODUCT((B2:B500=A2)*(E2:E500={"CT","NT"})*H2: H500)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"bob" wrote in message
...
Using an array, I need a formula for the following:

If B2 through B500 = A2
and
If E2 through E500 = "CT" or "NT"
then SUM H2 through H500

Thank you!

Bob