Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Learn SUMIF,SUMIFS,COUNTIF and COUNTIFS functions in Excel

Abdelrahman Abdou, Data Analyst & Excel Lover!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
4 Videos (27m)

    • SUMIF,SUMIFS Exercise


    • Countif and Countifs Exercise


About This Class

In this class, Students will learn how to use the SUMIF,SUMIFS,COUNTIF and COUNTIFS functions in Excel and understand the difference between them.

They will also learn how to use them to sum or count cells between two dates.

Exercises for using the functions are included on the class.

Files containing the examples and exercises are attached to the class.






Reviews (0)

Abdelrahman Abdou

Data Analyst & Excel Lover!

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

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 reports.

I love learning new things and my main learning method is through self-learning by watching video tutorials.

See full profile