=COUNTA(H:H)-COUNTIF(A:A,"No Show")

--

HTH

Bob

"Nathalie" wrote in message
...
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!!!!