Hi
Can anyone help. I'm using a excel and using a formula =COUNTIF('2015'!C9:C29,"f")/COUNTA('2015'!C9:C29)
I want to drag the formula across to the next column, but the data it is looking at is =COUNTIF('2015'!F9:F29,"f")/COUNTA('2015'!F9:F29) and it returns for D.
I want to be able to drag it across another 180 columns with it looking at every third column data set .
Hope that makes sense to someone, will be a very long winded way if i have to manually enter every column.
Many thanks
Steve
Bookmarks