I have attempted several ways to have column T return a zero if column U does not have a # in the cell. {=IF(U4>0,1,0)} Once the calculation in Column U has executed I want the cell in Column T to change to a 1 in order to count the "1" in a lower cell.
Column U has this formula {=IFERROR(INDEX(I:I,SMALL(IF($B$3:$B$80=$S$4,ROW($B$3:$B$80)),ROWS($1:1))),"")}


Capture.PNG