microsoft.excel.training - countif

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

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

microsoft.excel.training - Countif

resolvedResolved · Low Priority · Version 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.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips


Server loaded in 0.09 secs.