=countif(range,criteris) that is =countif(C5:C50,"withdraw")

"Spiky" wrote:

On Sep 17, 2:17 pm, "Bob Umlas" wrote:
=SUMPRODUCT(--(C4:C15="withdraw"),B4:B15)

Actually, this one will add them up. If the OP wants to count, try
David's formula instead.