>>106450533
Just type in
=COUNTIF(A1:A10, "Rejected")
for a cell's formula, replacing A with whatever column it is in, 1 for whatever your starting row is and 10 with whatever your ending row is. If you add a shit ton of rows, you can click the cell with the formula, then drag down to get the new rows.