Course Content

If you are facing any issue in playing video please use Firefox browser.

Course Content


This is a function in Excel that will allow you to sum the values of a range based on the criteria you provide. The formula =B2:B5=="John" would sum the values in B2 through B5, which are cells with values matching "John", to the range C2 through C5. The SUMIF function can help you filter numbers and find the total value that matches a specific condition. It requires three arguments.

Excel has a built-in function called "COUNTIFS" to count the number of cells that have a particular condition applied.Countifs is an Excel function that calculates the count of a specified range. Countifs can be used to count items in a range of cells such as the number of times a word appears in a document or the number of hours it took to complete a project. The formula for Countifs is: =COUNTIF(range,test)

The most important uses of an IF function in Excel are to create conditional formatting for the data in a spreadsheet and to create formulas that calculate values based on whether a particular condition is met or not. IF function: Excel allows you to create conditional formatting by using the IF function. The syntax for this function is: =IF(condition, value, [text]) It allows you to apply different formatting based on certain conditions. For example: If the value in cell B1 is greater than 10, then Excel will display bold text and red colors in A1. The most common use of an if the function is when it helps with calculations such as this one: If (A1 > 10) then A2 = 20 else A2 = 0

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere