Hi Ann

not sure about the sorting, but you can definitely use COUNTIF with cells
that have a drop down entry created using Data / Validation.

Hope this helps
Cheers
JulieD

"Ann Shaw" wrote in message
...
Hi I was wondering if it is possible to sort my
spreadsheet if there are combo boxes in the sheet and if
it is possible to run a countif formula including the
cells with the dropdown entries.

Many thanks

Ann