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

Project Description

Attached are the example files used on the class.

Please follow along with me using the example files.

Please try and re-write the functions on the example files to get Hands-on experience with the techniques explained in the class.

Student Projects