use of DCOUNTA

[smiwoon]

I have defined a range of fields in columns(by the name DRANGE) which
includes colums for grades A+, A, and A-. When I use the function DCOUNTA
for the range, the count for A also include count for A+ and A- which re not
suppose to be included. How do I overcome this problem? Please help.

 

[Frank Kabel]

Hi
try
=COUNTIF(A:A,"A")

 

[Debra Dalgleish]

In the criteria area, instead of typing an A, use: ="=A"

Or, if you have one criterion, instead of using a DCOUNTA formula, you
could use COUNTIF, e.g.: =COUNTIF(C2:C100,"A")