Question on DCOUNT

[LeeCC]

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

 

[Sean Timmons]

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]

Hello! Sean

Thank you. This is exactly what I want. I didn't know DCOUNT criteria can
accept wildcard.


Lee CC
-------------------------------------------------------------