I tried the formulas
=sumproduct(--(sheet1!f6:f52<="54"),--(sheet1!g6:g52<="9"))
=Countif(sheet1!f6:f52<=54)-Countif(sheet1!g6:g52<=9)
=(countif(sheet1!f6:f52,"<=54")0*(countif(sheet1! f6:52,"<=9")-)
and neither function produces the correct answer for me, which is 20.

I have two conditions also. I want my formula to compare range f6:f52 and
g6:g52 on sheet1 for employees who are <=54yo with <=9 yrs of service and
place my answer which should be 20 on sheet2 b3.

I have found in Help the following formula that is what I want to do;
however, it produces 0 for me.
=COUNT(IF((B2:B11="Suyama")*(D2:D11=1000),D2:D11) )
Please help.

Is countif the right formula?