Counts the number of cells containing numbers in a database that match specified conditions.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
DCOUNT(database, field, criteria)DCOUNT is a database function that counts numeric values in a column based on criteria you define. It is useful for filtering datasets and performing conditional counts without using complex array formulas.
=DCOUNT(A1:C10, "Age", E1:E2)תוצאה: 5
Counts the number of entries in the 'Age' column where the criteria in E1:E2 are met.
No, DCOUNT only counts cells that contain numeric values. Use DCOUNTA if you need to count non-empty cells regardless of content.