Help on formula =IF(SUMPRODUCT(COUNTIF(H3:H99, B3:B99))>0, "done", "in process")

[OXNARD208]

Why when using this formula on column f everything above f12 equals Done. When I just want f12 to equal done not everything above it.

Thank you,

 

[sheetspread]

Check if the condition is satisfied and the arrays are set as they should be, with $ signs if necessary.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...qual-b3-then-f-must-say-done.html#post5001077

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).