Using the Countif function in Excel

Launch Excel and type numbers as shown in the image below. Click on the Sum button on the ribbon and choose More Functions.

When you have a table with data, and you wish to retrieve specific information from it.

Conditional formatting enables you to highlight cells with a curtain color, depending on the cell’s value.

The ‘Pivot table’ might be the most powerful and efficient feature of Microsoft Excel 2007.

Whenever you have a big table, from which you want to show only certain rows that fulfill some criteria.

A formula is a way for you to make calculations based upon data written in the spreadsheet.

Whenever you want to present some text according to a criteria: if the criteria is met then present this text, if the criteria isn’t met present that text.

Or if you want to calculate somethin