Count Calculation

[Guest]

Hi,
Im looking to set up a calculation that counts every time
I pass a cummulative 1000 i.e like so

Cumm. 821 1245 3654 4012
Count 0 1 2 1

but I dont know how to do it...Any help please?

Nicky P

 

[JE McGimpsey]

Assuming Cumm. is in B1:E1, one way:


B2: =INT(B1/1000)
C2: =INT(C1/1000)-SUM($B2:B2)

Copy C2 over as far as necessary.