Hello!
I am trying to calculate how many times a cell changes to "Checked Out" and only when it changes to checked out. I frequently change the cell stratus from "Checked Out" to "On Shelf' and I cannot seem to find a formula where it will only count the times it was changed to "Checked Out."
I would ultimately like to count how many times this change occurs for a whole column, with a different counter for each cell in that column.
Is there anyone that can help me with this?
Thanks so much!
I am trying to calculate how many times a cell changes to "Checked Out" and only when it changes to checked out. I frequently change the cell stratus from "Checked Out" to "On Shelf' and I cannot seem to find a formula where it will only count the times it was changed to "Checked Out."
I would ultimately like to count how many times this change occurs for a whole column, with a different counter for each cell in that column.
Is there anyone that can help me with this?
Thanks so much!