COUNT IF NOT....
 

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.

COUNT IF NOT....
 

Try this...

=COUNTA(A1:J1)-SUM(COUNTIF(A1:J1,{"D","S","M"}))

--
Biff
Microsoft Excel MVP


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

COUNT IF NOT....
 

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.

COUNT IF NOT....
 

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.

COUNT IF NOT....
 

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