Need help creating a formula

[BettaB97]

I need some help creating a formula (not that good at excel at the moment).

Section A:

In the transfer section I need a formula (I think a countifs one) that will see the information in section B and give a total count for cells that have the same date as Section A as well as Transfer (so it would filter out data that is on other days, even if they have transfer)

Date	Transfer #
6/19/2022		<---- this is where formula would be needed
6/20/2022
6/21/2022

Section B:

6/19/2022	Transfer
6/20/2022	Other
6/21/2022	Duplicate
6/20/2022	Transfer
6/19/2022	Tranfer
6/19/2022	Other

I hope this makes sense in what I am trying to do

[#2]

@BettaB97 

=COUNTIFS($A$10:$A$15,A3,$B$10:$B$15,"Transfer")

This can be done with COUNTIFS as you mentioned.

=SUMPRODUCT(($A$10:$A$15=A3)*($B$10:$B$15="Transfer"))

An alternative could be SUMPRODUCT.