Excel functions / Database
DCOUNTA function
Counts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
Syntax
=DCOUNTA(database, field, criteria)
Arguments
database: The table, with its column labels in the first row.field: The column to work on: its label in quotes ("Profit") or its number counting from 1. Left empty, every matching row is counted.criteria: The conditions: a range with column labels in its first row and what to match below them.
When to use it
DCOUNTA counts the cells that are not empty in one column of a table, for the rows that meet conditions in a criteria range: numbers and text alike.
Examples
North orders with a rep filled in
A B C D E 1 Region 2 North 3 3 4 Region Rep Sales 5 North Ana 1200 6 South Ben 800 7 North Chloe 900 8 West Ana 400 9 North Ana 300 In E2:
=DCOUNTA(A4:C9, "Rep", A1:A2)→ 3
Common mistakes
- A space is not empty. A cell with a space in it counts as filled.
DCOUNTA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DPOČET2
- Danish: DTÆLV
- Dutch: DBAANTALC
- Finnish: TLASKEA
- French: BDNBVAL
- German: DBANZAHL2
- Hungarian: AB.DARAB2
- Italian: DB.CONTA.VALORI
- Norwegian: DANTALLA
- Polish: BD.ILE.REKORDÓW.A
- Portuguese (Brazil): BDCONTARA
- Portuguese (Portugal): BDCONTAR.VAL
- Russian: БСЧЁТА
- Spanish: BDCONTARA
- Swedish: DANTALV
- Turkish: VSEÇSAYDOLU