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

Learn practical ways to apply AI to save time, spark creativity, and make smarter decisions.
4 videos
27 min
Learn simple desk-friendly habits to reduce strain, improve posture, and stay comfortable during long hours at your workstation.
1 videos
2 min
Learn what stress really is, why it matters, and how to manage it through practical strategies that boost resilience and support sustainable performance.
4 videos
9 min
DEI unlocks innovation & fairness at work. Learn how to build a culture where everyone thrives ethically and profitably.
1 videos
2 min
Learn how stakeholder buy-in turns ideas into action through trust, alignment, and strategies that build lasting support.
3 videos
8 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