For each column I would like to count the total number of rows that had a 1 to the left and are now blank. (i.e. for R1 I would like to count week 3.)
This sheet represents resources joining and leaving a project. I would like to count the number of resources leaving the project each week.
I can't just sum the rows and take the difference as that does not account for new resources coming on and will miss resources leaving. Thinking some sort of CountIF, but can't quite get it.
And for the favor.
This sheet represents resources joining and leaving a project. I would like to count the number of resources leaving the project each week.
I can't just sum the rows and take the difference as that does not account for new resources coming on and will miss resources leaving. Thinking some sort of CountIF, but can't quite get it.
And for the favor.