COUNT IF NOT....

  • Thread starter Thread starter ExcelforDummies
  • Start date Start date
E

ExcelforDummies

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.
 
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---
 
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
 
Back
Top