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

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

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


.