IF
in [General]
|
From: Nathalie on 13 Apr 2010 11:03 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 13 Apr 2010 11:27 =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 13 Apr 2010 11:27 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 13 Apr 2010 11:31 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!!!! >
|
Pages: 1 Prev: Average using Sumproduct or .... Next: Averaging unique values |