Master Summing and Counting with Criteria using SUMIF SUMIFS COUNTIF COUNTIFS SUMPRODUCT functions | Abdelrahman Abdou | Skillshare

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 Videos (47m)
    • Class Intro

      0:52
    • Before we start the class

      0:17
    • SUMIF and SUMIFS Basics SkillShare

      13:55
    • Summing and counting between dates

      9:03
    • Summing and Counting between times

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

      14:50
    • 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

21

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

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.

Abdelrahman Abdou

Data Analyst & Excel Lover!

Hi, I'm Abdelrahman and I'm and Excel Lover :)

I'm also the founder of ExcelBonanza.com, a website dedicated to making you better at Microsoft Excel!

I have a Bachelor's Degree in Chemical Engineering.

I Work as MIS and Reporting Analyst in Vodafone International Services In Egypt.

I have more than 5 Years of Experience in Excel including building Dashboards and VBA.

I have created numerous dashboards in my company and automated tens of report...

See full profile

Report class