How to incrementally copy formula

[Excelfail]

I have a data set which I want to group easily into blocks. This is the formula I have:-

=COUNTIFS(Sheet1!I:I,">=0"(or A5),Sheet1!I:I,"<1"(or A6))

I want to keep the range the same and copy the formula down incrementing the blocks each time so it counts 0-1,1-2,2-3 etc., etc.

So the next formula should be:-

=COUNTIFS(Sheet1!I:I,">=1"(or A6),Sheet1!I:I,"<2"(or A7))

Can anyone help me?!

Thanks!

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?

=COUNTIFS(Sheet1!I:I,">="&A5,Sheet1!I:I,"<"&A6)

 

[Excelfail]

Absolutely perfect, thanks so much! I am really an Excel noob as you must realise! Is there a good list of operators and how to use them in the forum or elsewhere which you'd recommend?

Thanks.

 

[Peter_SSs]

Is there a good list of operators and how to use them in the forum or elsewhere which you'd recommend?

I would start by searching for 'operators' in Excel's built-in Help.