COUNTIF Troubles

[scottnoddin77]

Hello,
I am trying to make a count if function. I did a survey and I have a bunch of 1s 2s 3s 4s and 5s in a certain boxes and I am trying to count them. The problem is the boxes are not all in a row so I have to select each individually.
When I try to do the function I get a VALUE error.
This is what I have so far.
=COUNTIF((B5,B18,B31,E5,E18,E31,H5,H18,H31),1)
What can I do to fix this?
Thanks for the help.

[Paul]

Can you not use:

=COUNTIF(B5:H31,1)

?

If there are no other instances of the number 1 in that range of cells, you should be fine.

[scottnoddin77]

That is the problem though.
They are all different questions so I can only use the specific cells. Is that possible?

[Teethless mama]

Hello,
I am trying to make a count if function. I did a survey and I have a bunch of 1s 2s 3s 4s and 5s in a certain boxes and I am trying to count them. The problem is the boxes are not all in a row so I have to select each individually.
When I try to do the function I get a VALUE error.
This is what I have so far.
=COUNTIF((B5,B18,B31,E5,E18,E31,H5,H18,H31),1)
What can I do to fix this?
Thanks for the help.

Try this:

=SUMPRODUCT((MOD(ROW(B5:B31),13)=5)*(MOD(COLUMN(B5:H5),3)=2)*(B5:H31=1))