Count/IF with 3 conditions

[Fidbeck]

Can you guys help me modify this formula?

=COUNT(IF(Sheet3!C3:C33="F";AND(Sheet3!F3:F33="OFF";OR(ISBLANK(Sheet3!F3:F33)))))

What i'm looking for is to 1st check if column C has a F in it, if any is found, it should check if column F has either OFF or is blank It should return 0, otherwise it should return how many Fs it has found!!!

 

[DanteAmor]

Try:

=COUNTIFS(Sheet3!C3:C33,"F",Sheet3!D3:D33,"<>OFF",Sheet3!D3:D33,"<>")

 

[Fidbeck]

Worked.
Thanks a lor