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.

Think I figured it out with Countifs.

Thanks.

What about something conditional in the rows IF left is 1 then X and sum if for X at the bottom of each column

AZAG08 said:

---

What about something conditional in the rows IF left is 1 then X and sum if for X at the bottom of each column

---

Good Idea, but that will blow up my financial calcs running off this. Or I could add If's into all my finc. calcs.

the Countifs got it.

This is just a sample of the sheet. Its 2 years and hundreds of resources.

Glad you got it figured out