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

Excel Functions & Formulas: Count & Sum

32 minutes (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:

Related Courses

Uncover how proactive quality assurance strategies drive better outcomes, lower rework, and build long-term customer trust.
4 videos
11 min
Write sharper emails—fast! This funny 15-min course teaches clarity, conciseness, and formatting (with laughs along the way).
1 videos
7 min
Learn proven methods to build a winning team, validate your ideas, and achieve breakthrough growth as an entrepreneur.
1 videos
5 min
Explore four powerful ideation techniques to generate, refine, and test ideas for structured, user-focused innovation.
6 videos
13 min
Discover how employee engagement fuels success by driving performance and learn to measure its impact effectively.
4 videos
11 min

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