COUNTIF formula with dropdown cells
Solved
boulidore
Posted messages
91
Status
Member
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Hello,
Configuration: Windows XP / Internet Explorer 7.0
I have a table containing dropdown lists. I would like to use the COUNTIF function, but it only counts the last criteria of each dropdown list.
For example: I have a question with a yes or no choice.
When I ask it to count the number of yes, I always get 0. Counting the number of no works fine.
In another case, I have 5 choices. For the first 4, I always get 0, and for the last choice it does count my boxes.
Is it possible to use this formula with dropdown cells?
Thank you in advance.
Sabine
Configuration: Windows XP / Internet Explorer 7.0
I have a table containing dropdown lists. I would like to use the COUNTIF function, but it only counts the last criteria of each dropdown list.
For example: I have a question with a yes or no choice.
When I ask it to count the number of yes, I always get 0. Counting the number of no works fine.
In another case, I have 5 choices. For the first 4, I always get 0, and for the last choice it does count my boxes.
Is it possible to use this formula with dropdown cells?
Thank you in advance.
Sabine
7 answers
Hello
in principle there’s no reason for it not to work, if it works for a yes, it works for a no.
Could you tell us more about your fields and the formula or provide a model of what doesn’t work at:
http://www.cijoint.fr
and come back to place the link provided by the site here.
Looking forward to hearing from you
best regards
--
Let’s ask ourselves if we are not alone in understanding what we are explaining?
in principle there’s no reason for it not to work, if it works for a yes, it works for a no.
Could you tell us more about your fields and the formula or provide a model of what doesn’t work at:
http://www.cijoint.fr
and come back to place the link provided by the site here.
Looking forward to hearing from you
best regards
--
Let’s ask ourselves if we are not alone in understanding what we are explaining?
Damn, I'm at work and I don't have access to the site to upload my file; I'll do it from home, either this afternoon or tonight...
Well, I'm typing exactly the same formulas, and I've done several tests; that's how I noticed that it only works for the criteria placed at the end of my dropdown list.
My first tab containing my tables is named "Form to complete for the 1st appointment."
In my column C, I have all my responses to account for "yes" or "no."
So on the second tab, I type: =COUNTIF('Form to complete for the 1st appointment'!C:C,"yes") and it gives me 0 (even though I have "yes")
and for "no": =COUNTIF('Form to complete for the 1st appointment'!C:C,"no") and that works.
I tried removing the dropdown option and it works, but it really bothers me not to use this option...
Well, I'm typing exactly the same formulas, and I've done several tests; that's how I noticed that it only works for the criteria placed at the end of my dropdown list.
My first tab containing my tables is named "Form to complete for the 1st appointment."
In my column C, I have all my responses to account for "yes" or "no."
So on the second tab, I type: =COUNTIF('Form to complete for the 1st appointment'!C:C,"yes") and it gives me 0 (even though I have "yes")
and for "no": =COUNTIF('Form to complete for the 1st appointment'!C:C,"no") and that works.
I tried removing the dropdown option and it works, but it really bothers me not to use this option...
Re
I don't know if you will have access to this small template (made in Excel 2007 and sent in 97) that works well.
Just in case:
check that there is no problem between the label of the dropdown list and that of the COUNTIFs, nor in the cell formats
http://www.cijoint.fr/cjlink.php?file=cj201103/cijcWDwVO1.xls
Regards
Let's ask ourselves if we are not the only ones who understand what we are explaining?
I don't know if you will have access to this small template (made in Excel 2007 and sent in 97) that works well.
Just in case:
check that there is no problem between the label of the dropdown list and that of the COUNTIFs, nor in the cell formats
http://www.cijoint.fr/cjlink.php?file=cj201103/cijcWDwVO1.xls
Regards
Let's ask ourselves if we are not the only ones who understand what we are explaining?
Thank you very much for your answers Vaucluse, well I don't have access to it, computer security issues, pffff..
I'll check it out at lunchtime, thank you very much!!
I'll check it out at lunchtime, thank you very much!!
Well, here's my document: http://www.cijoint.fr/cjlink.php?file=cj201103/cijrtsWasw.xlsx
On yours in Vaucluse, it indeed works, and I tried to make my table on your doc, but it's not working for me, even if I try making a list like you (otherwise I just type my criteria directly into "data" -> "validity" and "list"...
Right now, I really don't see what's wrong; I think I've been looking at it too long. If someone has clearer eyes than mine, thank you very much!!
On yours in Vaucluse, it indeed works, and I tried to make my table on your doc, but it's not working for me, even if I try making a list like you (otherwise I just type my criteria directly into "data" -> "validity" and "list"...
Right now, I really don't see what's wrong; I think I've been looking at it too long. If someone has clearer eyes than mine, thank you very much!!