Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft.excel.training - countif

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.training - Countif

microsoft.excel.training - Countif

ResolvedVersion Standard

Hayley has attended:
No courses

Countif

how to use it?

RE: countif

CountIf works on the basis that if any value in the range you select meets your criteria, then it will be added to the count.

COUNTIF(range,criteria)

Range:
is the range of cells from which you want to count cells.

Criteria:
is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.