Countif function when range isn't continous

Hi,
Im trying to get the different index values from a questionnaire, but having som problems with a certain scale.

Basically im trying to find how many "3" there are in specific items. So i tried the countif function:

=countif((Q4,R4,AB4,AJ4,BP4,BT4,BW4,CH4,CJ4),3)

Which doesnt work. Is there some way how to use a noncontinous range for the countif function?

It works when i use indirect =SUM(Countif(INDIRECT({"X2","Y2","AI2"}),3))
but then i cant pull it down and use for the other 200+ subjects.

So there a simple way, or do i just need to put them in seperate
=countif(Q4,3)+countif(......+countif(CJ4,3)

Thanks,
/John

I didn't download your file.

Maybe something like this:

=INDEX(FREQUENCY((Q4,R4,AB4,AJ4,BP4,BT4,BW4,CH4,CJ4),{2,3}),2)