The most commonly used functions in Excel are those that count and add. You can count and add (sum) based on one or more criteria.
SCORE
To count the number of cells that contain numbers, use the function SCORE (COUNT).
=СЧЁТ(A1:A5)
=COUNT(A1:A5)
COUNTIF
To count cells by one criterion (for example, more than 9), use the function COUNTIF (COUNTIF).
=СЧЁТЕСЛИ(A1:A5;">9")
=COUNTIF(A1:A5,">9")
COUNTIFS
To count cells based on multiple criteria (for example, those containing “green” and greater than 9), use the function COUNTIFS (COUNTIFS).
=СЧЁТЕСЛИМН(A1:A5;"green";B1:B5;">9")
=COUNTIFS(A1:A5,"green",B1:B5,">9")
SUM
To sum a range of cells, use the function SUM (SUM).
=СУММ(A1:A5)
=SUM(A1:A5)
SUMMESLI
To sum cell values based on a single criterion (for example, greater than 9), use the function SUMMESLI (SUMIF). In this case, one column is used to test the condition and summation, so it is enough to fill in only two arguments in the function:
=СУММЕСЛИ(B1:B5;">9")
=SUMIF(B1:B5,">9")
To sum cell values based on a single criterion (for example, “green”), also use the function SUMMESLI (SUMIF). In this case, different columns are used to test the condition and summation, so three arguments need to be filled in the function, the last one is the range for summation.
=СУММЕСЛИ(A1:A5;"green";B1:B5)
=SUMIF(A1:A5,"green",B1:B5)
SUMMESLIMN
To sum cell values based on multiple criteria (such as “blue” and “green”), use the function SUMMESLIMN (SUMIFS). The first argument is the range to sum.
=СУММЕСЛИМН(C1:C5;A1:A5;"blue";B1:B5;"green")
=SUMIFS(C1:C5,A1:A5,"blue",B1:B5,"green")
Note: In a similar way, you can use the function HEARTLESS (AVERAGEIF) и SRZNAČESLIMN (AVERAGEIFS) to calculate the average of cells based on one or more criteria.