Copy COUNTIF formula vertically with changing horizontal column references

Hi Guys,
Working on a dashboard and I have a couple of formulas that works on a couple of drug items, I would love to count some varriables "Yes", "No" e.t.c. For example "=COUNTIF('Raw data template'!AP:AP,"YES")" this counts from the old sheet to the new sheet in cell B4. I have in the meantime manually incremented column references like this.
B4=COUNTIF('Raw data template'!AP:AP,"YES")"
B5=COUNTIF('Raw data template'!AQ:AQ,"YES")"
B6=COUNTIF('Raw data template'!AR:AR,"YES")"
B7=COUNTIF('Raw data template'!AS:AS,"YES")"
B8=COUNTIF('Raw data template'!AT:AT,"YES")"..........up to column BK

I Looked up the function offset but I have not got it working like below (the number of rows to be counted for each item is not fixed it might grow)

=COUNTIF(OFFSET('Raw data template'!AP$2, 0, ROW() +1, 15), "YES").

Any help will be greatly appreciated.

use the dollar sign "$ after the AP

Try this in B4,then drag down.

Please Login or Register  to view this content.

Worked perfect thanks a bunch