Autofill rows, increment column reference

[imagana]

I need a count if formula that can autofill downwards but increment the column references.

For Example,

A
row 1=countif('Sheet1'!H:H,1)
row 2=countif('Sheet1'!I:I,1)
row3=countif('Sheet1'!J:J,1)


and if possible have the column reference increment by 3, if not then the above is fine.

so the result can be
A
row 1=countif('Sheet1'!H:H,1)
row 2=countif('Sheet1'!K:K,1)


Thank you!

 

[Rick Rothstein]

Give this formula a try...

=COUNTIF(OFFSET(E:E,0,3*ROWS(A$1:A1)),1)

 

[imagana]

Rick,

Your formula worked Thank you so much!