Need help creating a formula

Occasional Contributor

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)

DateTransfer # 

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

1 Reply

@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.

countifs.JPG