Option Explicit
Sub Monthes12()
Dim i As Byte
Dim M As Variant
i = 2
For Each M In Array('January', 'Februray', 'March', 'April', 'May', 'June')
i = i + 1
Cells(6, i).Formula = '=SUMPRODUCT((ColU' & M & '<>7)*(ColPanne' & M & '=''o''))'
Next M
Range('D6').Select
End Sub