SUM(IF(OR
Try this...
=SUMPRODUCT(--(B2:B500=A2),(E2:E500="CT")+(E2:E500="NT"),H2:H500 )
--
Biff
Microsoft Excel MVP
"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
|