|
|
| Next: Outlook .pst transfer from 2007 to 2002 |
| Author |
Message |
ExcelforDummies
External
Since: Oct 28, 2009
Posts: 1
|
 Posted: Wed Oct 28, 2009 1:55 pm Post subject: COUNT IF NOT....
Archived from groups: microsoft>public>excel>worksheet>functions (more info?) |
|
|
|
| I have a work schedule and im trying to show days off. the rows consist of D
for days, S for swings and M for mids. I am trying to show on another colum
the number of days that a row does not contain a d,s, or m but will count
everything else as 1 and give me a total.
|
|
|
| Back to top |
|
 |
ryguy7272
External
Since: Dec 16, 2006
Posts: 59
|
Posted: Wed Oct 28, 2009 2:19 pm Post subject: RE: COUNT IF NOT.... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
This may be what you are looking for:
=SUMPRODUCT(--(A1:A10<>"D"),--(A1:A10<>"M"),--(A1:A10<>"S"))
Or, do you want to count things in the adjacent column?
HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"ExcelforDummies" wrote:
> I have a work schedule and im trying to show days off. the rows consist of D
> for days, S for swings and M for mids. I am trying to show on another colum
> the number of days that a row does not contain a d,s, or m but will count
> everything else as 1 and give me a total. |
|
| Back to top |
|
|
winnie123
External
Since: Aug 11, 2009
Posts: 6
|
Posted: Wed Oct 28, 2009 2:36 pm Post subject: RE: COUNT IF NOT.... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
you could try
=SUMPRODUCT(--(A2:C6<>"D"),--(A2:C6<>"M"),--(A2:C6<>"S"))
to get grand total
or to get each row total change range to A2:C2 for each instance
"ExcelforDummies" wrote:
> I have a work schedule and im trying to show days off. the rows consist of D
> for days, S for swings and M for mids. I am trying to show on another colum
> the number of days that a row does not contain a d,s, or m but will count
> everything else as 1 and give me a total. |
|
| Back to top |
|
|
T. Valko
External
Since: Nov 24, 2006
Posts: 3426
|
Posted: Wed Oct 28, 2009 5:07 pm Post subject: Re: COUNT IF NOT.... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Try this...
=COUNTA(A1:J1)-SUM(COUNTIF(A1:J1,{"D","S","M"}))
--
Biff
Microsoft Excel MVP
"ExcelforDummies" <ExcelforDummies.RemoveThis@discussions.microsoft.com> wrote in
message news:15DBD183-0B5D-473B-AC9B-6DFC908373B7@microsoft.com...
>I have a work schedule and im trying to show days off. the rows consist of
>D
> for days, S for swings and M for mids. I am trying to show on another
> colum
> the number of days that a row does not contain a d,s, or m but will count
> everything else as 1 and give me a total. |
|
| Back to top |
|
|
Ashish Mathur
External
Since: May 21, 2005
Posts: 238
|
Posted: Thu Oct 29, 2009 1:10 pm Post subject: Re: COUNT IF NOT.... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Hi,
Use this. I19:I21 has S, D and M. I10:I16 has the data.
=SUMPRODUCT(1*(ISERROR(MATCH(I10:I16,$I$19:$I$21,0))))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"ExcelforDummies" <ExcelforDummies.DeleteThis@discussions.microsoft.com> wrote in
message news:15DBD183-0B5D-473B-AC9B-6DFC908373B7@microsoft.com...
> I have a work schedule and im trying to show days off. the rows consist
> of D
> for days, S for swings and M for mids. I am trying to show on another
> colum
> the number of days that a row does not contain a d,s, or m but will count
> everything else as 1 and give me a total. |
|
| Back to top |
|
|
|
|
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
| |
|
|
Microsoft Office