Hey guys,

I'm not sure if this qualifies as a basic Excel question or not, but I'm having an incredible hard time getting the autofill to follow the pattern that I set for it.

In the first three cells of the series I have the following:

=IF((COUNTIF(F3:F12,"Hello!"))>=1,"Hello!","Not Hello!")
=IF((COUNTIF(F13:F22,"Hello!"))>=1,"Hello!","Not Hello!")
=IF((COUNTIF(F23:F32,"Hello!"))>=1,"Hello!","Not Hello!")

As scene here, incrementing the cell range by ten every time is my goal. Yet when I select the series and drag to fill down the row my desired length, instead of catching the pattern, it instead increments the next cells in the series by 1 instead of 10, like follows:

=IF((COUNTIF(F24:F33,"Hello!"))>=1,"Hello!","Not Hello!")
=IF((COUNTIF(F25:F34,"Hello!"))>=1,"Hello!","Not Hello!")
=IF((COUNTIF(F26:F35,"Hello!"))>=1,"Hello!","Not Hello!")

Can someone please tell me what I'm doing wrong and if there is something else I need to do in order to get the autofill to follow my pattern and increment by 10 instead of 1.

Thank you and all the best,

ExcelRogue