Auto Adding

[mrdevon]

Hi there I'm new to excel and this forum but I would like help with a formula that adds +1 to a cell when another cell reaches a certain number

eg - cell B4 reads 9 when it reaches 10 it would add +1 to say cell H14 and then again when it reaches say 15 so cell H14 would now display 2 and so on

Thanks

 

[gsistek]

Try
=ROUNDDOWN(B4/5,0)-1

 

[mrdevon]

Try
=ROUNDDOWN(B4/5,0)-1

No thats doesn't work for what I need as the number I want to count can very

example cells A1:A10 would read

82
104
122
94
62
88
53
129
144
167

Everytime a number over say 100 is seen it would add +1 to B1, over 120 to B2 and over 140 to B3

 

[gsistek]

I'm not quite sure I follow exactly what you're trying to do. Could you provide the desired output for the example you gave?

 

[mrdevon]

I don't have the file on the computer I'm on but what I want is this....

I have a sheet where column A has a series of numbers that can be anything from 1 to 500, now in say B1 I would like it to tell me how many times the number 25 appeared B2 the number 66, B3 148, B4 212, B5 289 etc

 

[gsistek]

Try in B1 =COUNTIF(A:A,25)
in B2 =COUNTIF(A:A,66)
and so on.

 

[mrdevon]

Thats brilliant thanks

Just one more thing is there something I can add into the formula to count all numbers over a certain amount if needed such as B1 =COUNTIF(A:A,(over)25)

 

[gsistek]

For over 25 use =COUNTIF(A:A,">"&25)
For greater than or equal to 25 use =COUNTIF(A:A,">="&25)

 

[mrdevon]

Thats fantastic quickly tested it on a random set of numbers and it does exactly as I want

 

[gsistek]

Glad I could help!