You can place the value in your drop down into a cell and then reference that
cell in your countif formala. I typically put the value selected in the drop
down in the cell behind the drop down box. For example, if your drop down
box is over cell "F1", then you can put "F1" in the LinkedCell property for
the drop down box. When you select "Yes", "No", or "Total" it will place
that value in cell "F1". Then your countif formula should look as follows:
=countif(range, F1)

"BCowans" wrote:

I have a cell that has a drop down menu with "yes", "no", or "total". I need
to count how many lots are in a particular part of town in another cell, but
it should count depending on the drop down menu. Here is what I need to do:

If the drop down has "yes" selected, I count all the lots on the next
worksheet in Column "A" that has a "yes" in it.
If the drop down has "no" selected, I count all the lots on the next
worksheet in Column "A" that has a "no" in it.
If the drop down has "total" selected, I count all the lots.

I cannot figure out how to give the function multiple criteria.

Tahnks for any help you can give.
BCowans