Malcolm torishi
Board Regular
- Joined
- Apr 26, 2013
- Messages
- 219
Hi
can anyone tell me if there is a formula that constantly adds a 1 to a cell value each time a 1 appears in another cell. EG
columnA Row 2:4 has 3 people’s names in each cell , column B row 2:4 as a 1 in each cell, each time the person in column A leaves the building, what I want to do is in column C have a running total of the number of times that person as left the building. So each time a person leaves there will show 1 next to his name in column B and when he returns the 1 gets deleted but if he goes out again a 1 will appear in column B again and I want to constantly keep adding the number of times he goes out to column C
thank you
can anyone tell me if there is a formula that constantly adds a 1 to a cell value each time a 1 appears in another cell. EG
columnA Row 2:4 has 3 people’s names in each cell , column B row 2:4 as a 1 in each cell, each time the person in column A leaves the building, what I want to do is in column C have a running total of the number of times that person as left the building. So each time a person leaves there will show 1 next to his name in column B and when he returns the 1 gets deleted but if he goes out again a 1 will appear in column B again and I want to constantly keep adding the number of times he goes out to column C
thank you