From: Nathalie on
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!!!!

From: Bob Phillips on
=COUNTA(H:H)-COUNTIF(A:A,"No Show")

--

HTH

Bob

"Nathalie" <Nathalie(a)discussions.microsoft.com> wrote in message
news:D4D54668-82FA-4643-B9F8-F9E7A9385CE4(a)microsoft.com...
>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!!!!
>


From: Pete_UK on
Possibly this:

=SUMIF(A:A,"<>"&"no show",H:H)

although I'm not sure if you do want a SUM rather than a COUNT.

Hope this helps.

Pete

On Apr 13, 4:03 pm, Nathalie <Natha...(a)discussions.microsoft.com>
wrote:
> 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!!!!

From: Roger Govier on
Hi Nathalie

you haven't given us much to go on here.
Maybe
=SUMPRODUCT((--($A$2:$A$1000<>"No Show"),$H$":$H$1000)

Change the ranges to suit.
--
Regards
Roger Govier

Nathalie wrote:
> 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!!!!
>