Hi All,
I have 2 workbooks set up. I currently have them named as Pipeline Test and Caseload Test.

On the Caseload test i want to use a count formula, and count how many times 1 person's name appears in Column I on the Pipeline Test workbook if Column M has "Yes" in the cell.

So i was thinking i would need a COUNTIF and AND formula to get this to work. I may be going to wrong way with this formula, so any help will be appreciated

Basically the Pipeline Test workbook will show what we have due in and who that has been allocated to, and the Caseload test will count 1 persons name to see what is due in for them (obviously the number will change as more gets added to the Pipeline Test workbook).
The Pipeline Test currently has each row highlighted a colour if it has come in, but i dont know if we can use a formula to only count the ones not highlighted in a colour and are due to come in

Hopefully this all makes sense, i have tried to add in as much information to make it easier to understand what i am trying to do

Thanks