Third post- By Julieta Echarri, Alexia Descovich, Mercedes Albrecht and Juana Casado

Functions:

First we have the function COUNT. COUNT is a function that counts the cells that contain numbers (dates also count as numbers).

We also have COUNTA. We use this function to count the cells that contain any type of data (numbers, letters, etc…). To use it, you have to select a cell, type “=COUNTA” and select the column (or columns) you want to count.

To count the quantity of blank cells, you can use COUNTBLANK. There you must select a column or many columns and it automatically counts the quantity of blank spaces. COUNTBLANK also counts the cells that appear empty when you click away from them.

You also can use COUNTIF to count the cells that fit a certain criteria. First you type “=COUNTIF” and then you select the range of cells you want to count. Secondly, you select the criteria that the cells in the range have to fulfill.

If you are using the COUNTIFS function, it’s because you want to count different criteria across multiple ranges. First you type “=COUNTIFS”, then you type where you’re looking for and then what you’re looking for.  You can repeat this last step multiple times.

SUMIF is a function that sums numbers that meet the required criteria. After inserting “=SUMIF”, you type in the range, the criteria and the sum_range. This last step is optional and it’s the range of cells to count together. If it doesn’t get added into the formula, the range is used instead of the sum_range.

The SUMIFS function is the most complex one. It sums the cells that meet multiple criteria. First you type the sum_range, then the first range and then the first criteria. After that, you can keep going and add more ranges and more criteria.

293 Words