Question on DCOUNT

  • Thread starter Thread starter LeeCC
  • Start date Start date
L

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
 
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)
 
Hello! Sean

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


Lee CC
-------------------------------------------------------------
 
Back
Top