Microsoft Excel Functions & Formulas

Use the DCOUNTA function to count all cells

beginning with the same character

Continuing with the previous example, now we want to count all

cells that begin with the letter “b,” like bread, beef steak, and

bananas. To do this, use the DCOUNTA function, which counts the

nonblank cells in a column of a list or database that match the speci-

fied conditions.

The arguments are the same as used with the DCOUNT

function.

4

To count cells beginning with the letter “b”:

1. Copy range A1:E1.

2. Select cell A14 and press <Ctrl+V>.

3. In cell B15 type b*.

4. In cell C17 type the following formula:

=DCOUNTA(A1:E11,E14,A14:E15).

5. Press <Enter>.

Database Functions 203 ...