Sorry to be asking again but the CountIf just won't work
for me in the cell range where the combo boxes are - how
can I do this?

Ann
-----Original Message-----
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


.