Is there a way to use a countif formula if the cell reference is a formula as well?

Ivan Bowskill

Hi All,

Any help would be appreciated.

I get #NO MATCH when I run the below formula. Is it an issue with a formula referencing a formula?

 

="Not Completed: " + COUNTIF([Column3]2:[Column3]24, FIND("Not Completed", @cell) > 0)

sean59916

Ivan - 

Can you provide a screenshot? I mocked this up and the formula is working fine using what you had provided.

Sean