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
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!