Countifs with Index Match circular reference issue

Sfisher

I'm using Index Match Value to pull data from previous matching task and predecessor info. I'm trying to add a Countifs funtion for conditional formating purposes. It works in the 1st cell until I copy the function across to include the cell I want the count it. I'm assuming because that cell is in the index range but it's not actually the cell I'm counting. Thoughts on how to get around the circular reference error?

Lucas Rayala

Hi @Sfisher -- can you maybe screenshot this? It's a little difficult to image what you're saying.