count on two variables

[dakk]

column a with steps 1, 2 &3
column b has sent email, made contact, etc

What I need is a formula that will count all of column a with 3. if column b=sent email

Thank you in advance

 

[barry houdini]

Try

=SUMPRODUCT(--(A1:A100=3),--(B1:B100="sent email"))

adjust ranges as necessary but they shouldn't be whole columns

 

[dakk]

It does not work

I actually have column a 3. Active lead (2-way) as a description

I tried using a * for the varible factor after the 3

It also did not work

 

[barry houdini]

Try

=SUMPRODUCT(--(LEFT(A1:A100)="3"),--(B1:B100="sent email"))

 

[dakk]

perfect. thank you so much