countif + match help please

[RobertM01]

Hi Gurus,
I am trying unsuccessfully to create a formula that will count the number if times text appears, that will then match a separate value.
eg: how many times does "Buy" appear down a column, for a currency pair, ACAD.
I then want to break this up to show how many buys were profitable or losers.
the spreadsheet attached shows what I am looking for.

Thanks in advance

[martindwilson]

use countifs
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy")
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy",$N$6:$N$41,"p")
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy",$N$6:$N$41,"l")

[RobertM01]

Hi Martin,
Thank you for the rapid and excellent response.
The formula works wonderfully.
Appreciate your help