=SUMPRODUCT(('Domestic #''s '!B3:B152="Assigned")*('Domestic #''s
'!K3:K152="New"))

Am I using the right formula? I want to count the amount of times Assigned
and New are both selected. They are on different columns. But the counts I
get are wrong when I manually filter. I checked to make sure there are no
leading spaces i.e _assigned, etc.... I am using a drop down to select
Assigned and New so figure it is not the case. Any other ideas or am I using
the wrong formula.

Thanks