count based on two fields - need quickly

[JO]

HELLO,
I am trying to get a count based on two fields.
I want to return the count based on if cells in col B = X and cells in col
A = Y
I have tried "=COUNTIF(H23:H999,A1) + COUNTIF
(B23:B999,A8)" but it is giving me the count of the result plus the count
of the second result.
Can anyone help.

 

[Aladin Akyurek]

=SUMPRODUCT(--($H$23:$H$999=A1),--($B$23:$B$999=A8))