use of DCOUNTA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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")
 
Back
Top