| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Hybrid Mode
