In DCOUNT, under Criteria, I have a few column headers, say Index, Class,
Score. The Index column in the data base is of the format "Axxxx", "Cxxxx",
"Bxxxx", "Axxxx", "Axxxx", and so on (where xxxx are numerics).

The cells to be counted is under the Score column with some conditions under
Criteria.

Can I set criteria under Index to count only indices that start with "A", by
using the LEFT() function?

Thanking for your advice in anticipation.


Lee CC