Countif when cells filtered

Hi

I've tried this formula mention before https://exceljet.net/formula/count-v...-with-criteria
and I just dont understand it for me to be able to use it in my sheet. I don't reallly get what offset means, and everytime I've tried different ways I keep getting formula error messages, any help on this would be greatly apprecaited