Excel's basic functions summarize a range of cells. SOMME (SUM) adds, MOYENNE (AVERAGE) calculates the mean, MIN and MAX give the smallest and largest value, NB (COUNT) counts numeric cells and NBVAL (COUNTA) counts non-empty cells. They ignore text and empty cells.
Example
=SOMME(B2:B20)