I have a formula (thanks to Barry!) that reports a result (text = 'imcomplete') when the preceding 5 cells in a row are not all filled out. The table may have no results of "incomplete" visible (in column 6 of my table) or one or more showing in my table. I want to be able to present a visible clue at the top of the sheet that shows unfinished records. I don't need anything smart, I just want cell F2 to show the text "INCOMPLETE ENTRIES EXIST BELOW" when 1 or more cells return the message "imcomplete" in the range F10:F100. I tried using the counta command, but a formula exists in every cell and it finds every cell not blank. Any ideas?