Question on DCOUNT
 

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

Question on DCOUNT
 

May be best to have a separate crtieria list and use A* as your search. So,
your criteria list would be in, say, A1:A2 with A1 as header and A2 as
crtierion. enter A* in A2. Then, DCOUNTA(A3:A500,1,A1:A2)

"LeeCC" wrote:

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