I am guessing that it's an IF

Column H: Sums the total of client
Column A: keeping track of clients that are "no shows"


How can I sum the number of clients in column H but minus the number of
clients that are a no show in column A.

Thanks for the help!!!!