Count multiple numbers from an importrange column

[mtaylor]

Hi Team
I am importing a large number of results and I would like all the 4s and 5s counted.

I have the following formula already in place which counts the 4s, wanted to add in a section to include 5s also.

=Countifs(ImportRange("Google Sheets - create and edit spreadsheets online, for free.","Grade 9!N3:N22"),"4")

Thank you in advance

Matt


Note: This is a Google Sheets question

 

[MrSyyr]

in excel something like this?
={COUNTIF(ROUNDDOWN((A1:A9)/2),"2")}