Loop Column reference in VBA Countif

Could somebody help me with this loop? I would like to compact this Countif to just a single line with the variable being passing thru as columns.

I can fix the half to the left of the equal sign, but how can can I loop the column numbers? My attempts so far have failed so any help is appreciated.

The columns to loop are 20, 4, 38, and 4, but of course there are more which I can easily put in once set on the right path.

The 2nd criteria range in the Countif is always the same with the 2nd criteria already run through a For Each structure.

Please Login or Register  to view this content.

Edit: I attached a sample workbook but limited the columns

Hello Jeff,

Here's a suggestion. Different loop structure but only one countif formula:

Please Login or Register  to view this content.

Thanks GC, works perfectly...