Master Summing and Counting with Criteria using SUMIF SUMIFS COUNTIF COUNTIFS SUMPRODUCT functions

Abdelrahman Abdou, Data Analyst & Excel Lover!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Lessons (47m)
    • 1. Class Intro

      0:52
    • 2. Before we start the class

      0:17
    • 3. SUMIF and SUMIFS Basics SkillShare

      13:55
    • 4. Summing and counting between dates

      9:03
    • 5. Summing and Counting between times

      7:24
    • 6. Learn the power of the SUMPRODUCT function!

      14:50
    • 7. Thanks for Watching!

      0:18

About This Class

In this class, Students will learn how to sum and count with one or more criteria using the SUMIF, SUMFS, COUNTIF and COUNTIFS functions in Excel

Students will also learn how to sum and count between dates and times using SUMIF, SUMFS, COUNTIF and COUNTIFS functions in Excel.

Students will also learn the power of the SUMPRODUCT function and how they can use it to sum and count with AND and OR Criteria in Excel.

Excel Date and Time MasterClass:

https://skl.sh/2Q9h2dj

 Watch my Excel Custom Number formatting Masterclass here:

https://youtu.be/lC6amUM-jTE