how to do this?

[jefftracy]

I am trying to make so if there is a 1 in c3:c32 then it counts it if there is a 2 in the same range I would like it to also count but only count 1 for every 2 if that makes any sense. is there a way to do this?

thanks in advance

[Ron Coderre]

Try this:
=SUM(COUNTIF(C3:C32,{1,2}))

Does that help?

Regards,
Ron