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.

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.

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.

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.

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.