Counting persons in "Assigned To" Column


Hi! I'm trying to count the number of times a person shows up in an "Assigned To" column. I have Sara, Sally, and Simon. For some reason, my formula returns 0 even though I have 2 "Sara"s, 4 "Sally"s, and 1 "Simon".

=COUNTIF({Other project Range 2}, FIND("Sara", @cell) > 0)

What could be missing?

Thanks ~ Cindi

Best Answer

  • Cindi Meche
    Cindi Meche ✭✭✭
    Answer ✓

    I think it may be partially user error? I got it to work by going by through every portion of the equation... this is what is now working:

    =COUNTIF({MASTER - Marketing Projects '21 Range 7}, FIND("Sara", @cell) > 0)