counting with 2 different criteria
 

=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

counting with 2 different criteria
 

Try
=SUMPRODUCT(--(B3:B152="Assigned"),--(K3:K152="New"))

I have removed the Sheet name to simplify things... First test on "'Domestic
#'s " sheet itself then you can add back the name.

-- converts True or False values to 1 & 0 so that they can be added...
"Roman" wrote:

=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