COUNT function with two criteria

[bixha1978]

Hi

Can help me out how to use the COUNT function with two criteria?
So I like to count how many Type A are IN and how many Type A are out so than with B.C etc see attachment

 

[bixha1978]

Hi

Can help me out how to use the COUNT function with two criteria?
So I like to count how many Type A are IN and how many Type A are out so than with B.C etc see attachment

 

[hagia_sofia]

Hello, try:

=COUNTIFS($B$2:$B$13,$B16,$C$2:$C$13,"Out")

=COUNTIFS($B$2:$B$13,$B16,$C$2:$C$13,"In")

 

[bixha1978]

Hello, try:

=COUNTIFS($B$2:$B$13,$B16,$C$2:$C$13,"Out")

=COUNTIFS($B$2:$B$13,$B16,$C$2:$C$13,"In")

Thanks

 

[Joe4]

bixha1978,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.