CountIf Macro for Relative Columns

[SamNC]

Hello!

I am relatively new to using VBA and am struggling to generate a macro.

What I would like to do is generate a macro to perform a countif function on a column, to see how many individuals selected "1" on a 1-5 rating scale, then do the same countif function for ratings 2-5.

I will need to perform this calculation on multiple (possibly hundreds of columns).

Is there a fairly simple process to have the Countif macro generate the total 5 countif scores, evaluating each column individually?

Thanks!