Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!

Business microlearning from Japan’s No1 MBA


Excel Functions & Formulas: Count & Sum

00h 32m (1 section)

Course Description

When dealing with large amounts of data, counting the number of times values appear, or finding a total of certain values becomes essential.
Basic Excel functions such as COUNT and SUM are there to help your descriptive analysis.

This course covers how to:
• Use the COUNT, COUNTIF, COUNTIFS and SUM, SUMIF, SUMIFS functions to quickly count and add data,
• Use the LEN, SUM and SUBSTITUTE functions to count characters,
• Use the SUM and LARGE functions to calculate the sum of the largest numbers in a range of cell,
• Use the COUNTBLANK and COUNTA functions to count blank and nonblank cells,
• Combine the not-equal-to operator with the IF and COUNTIF functions,
• Use the COUNTIF and ISLOGICAL functions to count all cells with text and logical values,
• And, use the SUMPRODUCT function to calculate the sum of the products of particular value.

Join us, and explore how these functions enable dynamic calculations as your data or criterion changes.

Share this course:

Start your free trial

Sign up to watch the rest of this course for free - no strings attached!
Continue with a subscription of USD 16.67 / month* after free trial ends
*USD 99.99 billed every 6 months