How do i set up a counter?
 

I would like a cell to advance by one every time the F9 key is hit. Is there
any way to set something like this up? If not, is there a way to easily
advance a cell by one? Thank you.

How do i set up a counter?
 

This is too hard to understand - something simple like
column B in wks 1 - if column A in wks 1 = column in summary wks = value /
else 0

"Bulldog21" wrote:

I would like a cell to advance by one every time the F9 key is hit. Is there
any way to set something like this up? If not, is there a way to easily
advance a cell by one? Thank you.

How do i set up a counter?
 

If you really want a counter, you have to ensure iterations is checked (menu
Tools|Options|Calculation tab), because of a circular reference. You should
also change the value in max iterations to 1, or it will 'jump' 100(or
whatever the value is). You should also want a 'reset' to reset your count as
needed. Say A1 is your counter, and B1 is your reset.
A1: =IF(B1=1,resetvalue,A1+1)
B1: 0 or 1 (or you could even tie it in if you like to the value of A1
B1: =IF(A1=100,1,0)

NOTE: Calculations take place in a specific order row 1, A thru IV, then row
2, etc...
This is important.
say A1=99
you press F9
A1 calculates first to go to 100, then B1 evaluates, and changes to 1, since
A1 is no longer less than 100, but A1, until the F9 is pressed, remains at
100 because it already calculated.
--
John C


"Bulldog21" wrote:

I would like a cell to advance by one every time the F9 key is hit. Is there
any way to set something like this up? If not, is there a way to easily
advance a cell by one? Thank you.