Description
A common task is to count how many elements satisfying a particular criterion we have in our data. For example, when working with a business cash flow statement with a daily breakdown, you may be interested in how many days daily cash flow exceeded £100.
This session looks at how to use the COUNTIF function to count elements satisfying a particular criterion.
After completing this session, you will be able to use the COUNTIF function to count occurrences of elements that satisfy a numeric or text criterion.
Instructions:
- Please complete the course, review questions, and successfully complete the qualified assessment with a minimum of 100% accuracy within one year of course enrolment.
- To retake the course, please refresh your browser and the course will start again.
Instruction before the Final Exam:
- The following exam will test your knowledge of this course.
- You can take it as many times as you want.
- You must have a score of 100% to pass this exam.
- You are required to complete the qualified assessment within one year of the date of purchase or enrolment.
- You must pass this exam to receive continuing education credits.
- You would need to retake the course before attempting the qualified assessment again.
- To redo the course after passing, you would need to reset the course.
- You won’t be awarded additional CPE if you re-take the qualified assessment after passing once.
- Please fill in and submit the survey after passing final exam to get CPE and Certificate of Completion.
