Google Sheets-funktion

COUNT

Counts the number of cells that contain numbers in a range or list of arguments.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

COUNT(value1, [value2], …)

The COUNT function is used to get the number of entries in a number field that are in a range or array of numbers. It ignores empty cells, logical values, text, or error values within the range.

Argument

value1obligatorisktThe first item, cell reference, or range within which you want to count numbers.
value2valfrittAdditional items, cell references, or ranges up to 255.

Exempel

=COUNT(A1:A5)

Resultat: 3

If A1:A5 contains {10, 'apple', 20, '', 30}, the function returns 3 because it counts only the numbers.

Vanliga frågor

Does COUNT include text values?

No, the COUNT function only counts cells that contain numbers.

Relaterade funktioner

COUNTA COUNTIF COUNTIFS COUNTBLANK