Countif incremental increase

[mojo300]

I have a column of various numbers
in column B
I have the following formula COUNTIF($B2:$B2218,"=0"),
Is there a way for me to have this formula incrementally increas as I drag it over
so I would want it to go to:

COUNTIF($B2:$B2218,"=0")
COUNTIF($B2:$B2218,"=1")
COUNTIF($B2:$B2218,"=2")
COUNTIF($B2:$B2218,"=3")
COUNTIF($B2:$B2218,"=4")

Etc.

Thanks

 

[Nine Zero]

Do a helper column, assuming your formula now is in column A going down, go to column C and input numbers 0 thru however much you want and then change your formula to this

=COUNTIF($B$2:$B$2218,"="&C1)

And drag down

 

[Marcelo Branco]

Try

=COUNTIF($B2:$B2218,ROWS(A$1:A1)-1)
and copy down

M.

 

[Eric W]

Let's say your formula is in column E, and you're dragging it to the right. Then try:

=COUNTIF($B2:$B2218,COLUMNS($E3:E3)-1)

 

[mojo300]

Let's say your formula is in column E, and you're dragging it to the right. Then try:

=COUNTIF($B2:$B2218,COLUMNS($E3:E3)-1)

Awesome
Thank You very much

 

[Eric W]

Glad we could help!