Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
I have a calendar that tracks employees attendance problems. On the left of
each is a cell with the month. To the right alternating rows of the day of the week and below it a drop down function linked to a list. When a selection is made in the drop down it posts to a cell with the formula " =countif(December,$228) the problem I have added three drop down cell below but have been unable to make the add to the list. The cells are obviously linked to the "month" cell. I expanded the month cell to correspond with the added rows and still no success. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
Hi,
I'm not a hundred percent clear on this one but The best way to display a drop down list in most cases is to use the Data, Validation, List choice and specify the range where the list is in the Source box. -- If this helps, please click the Yes button Cheers, Shane Devenshire "HRM Hawaii" wrote: I have a calendar that tracks employees attendance problems. On the left of each is a cell with the month. To the right alternating rows of the day of the week and below it a drop down function linked to a list. When a selection is made in the drop down it posts to a cell with the formula " =countif(December,$228) the problem I have added three drop down cell below but have been unable to make the add to the list. The cells are obviously linked to the "month" cell. I expanded the month cell to correspond with the added rows and still no success. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
Shane
Thank you for your response. My drop downs work fine they just don't add to the the cell that gathers the data total in the prospective spreadsheet. "Shane Devenshire" wrote: Hi, I'm not a hundred percent clear on this one but The best way to display a drop down list in most cases is to use the Data, Validation, List choice and specify the range where the list is in the Source box. -- If this helps, please click the Yes button Cheers, Shane Devenshire "HRM Hawaii" wrote: I have a calendar that tracks employees attendance problems. On the left of each is a cell with the month. To the right alternating rows of the day of the week and below it a drop down function linked to a list. When a selection is made in the drop down it posts to a cell with the formula " =countif(December,$228) the problem I have added three drop down cell below but have been unable to make the add to the list. The cells are obviously linked to the "month" cell. I expanded the month cell to correspond with the added rows and still no success. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
hi
your counif formula doesn't seem to have a range to count. is this formula correct? if so then you should be getting an error. the syntax for countit is.. =countif(range,criteria) Regards FSt1 "HRM Hawaii" wrote: Shane Thank you for your response. My drop downs work fine they just don't add to the the cell that gathers the data total in the prospective spreadsheet. "Shane Devenshire" wrote: Hi, I'm not a hundred percent clear on this one but The best way to display a drop down list in most cases is to use the Data, Validation, List choice and specify the range where the list is in the Source box. -- If this helps, please click the Yes button Cheers, Shane Devenshire "HRM Hawaii" wrote: I have a calendar that tracks employees attendance problems. On the left of each is a cell with the month. To the right alternating rows of the day of the week and below it a drop down function linked to a list. When a selection is made in the drop down it posts to a cell with the formula " =countif(December,$228) the problem I have added three drop down cell below but have been unable to make the add to the list. The cells are obviously linked to the "month" cell. I expanded the month cell to correspond with the added rows and still no success. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
Hi,
You mention Countif in the subject line, but that doesn't seem to be relevant to the discussion. Also, what is the actual formula? It may have nothing to do with the drop down list. -- If this helps, please click the Yes button Cheers, Shane Devenshire "HRM Hawaii" wrote: Shane Thank you for your response. My drop downs work fine they just don't add to the the cell that gathers the data total in the prospective spreadsheet. "Shane Devenshire" wrote: Hi, I'm not a hundred percent clear on this one but The best way to display a drop down list in most cases is to use the Data, Validation, List choice and specify the range where the list is in the Source box. -- If this helps, please click the Yes button Cheers, Shane Devenshire "HRM Hawaii" wrote: I have a calendar that tracks employees attendance problems. On the left of each is a cell with the month. To the right alternating rows of the day of the week and below it a drop down function linked to a list. When a selection is made in the drop down it posts to a cell with the formula " =countif(December,$228) the problem I have added three drop down cell below but have been unable to make the add to the list. The cells are obviously linked to the "month" cell. I expanded the month cell to correspond with the added rows and still no success. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF using OR | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |