Excel Formulas for Counting and Adding: COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS and IF Functions - Part 2
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Learn essential Excel formula techniques for counting and adding in this comprehensive 52-minute video tutorial taught by experienced Highline College Professor Mike Girvin. Master 10 different Excel Built-in Functions including COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS, and IF through practical business examples. Explore how to perform calculations with single and multiple conditions using AND/OR Logical Tests, work with array formulas in MS 365, understand the Spilled Range Operator, and create dynamic sales reports. Discover the differences between Accounting and Currency formatting, learn to handle text formulas with ampersands, troubleshoot #NAME errors, and build assembly line time reports using SEQUENCE, MAXIFS, and MINIFS functions. Practice newly acquired skills with provided exercise problems and access downloadable Excel files and PDF notes for hands-on learning.