View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
winnie123 winnie123 is offline
external usenet poster
 
Posts: 129
Default 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.