Quadra

Connecting Technology and Business.

Sumifs and Countifs in Excel

‚ÄčLet us assume that you have a range of numbers in an Excel worksheet. You want to sum all numbers in the range that fall under a certain condition. You also want to know how many such numbers are there in that range that satisfy the condition. Here is how you can do this:

Go to the cell where you want the sum of the numbers that fall under the condition

Enter the formula =sumif(range, condition). For example, if you want sum of all numbers that are less than 500 in the range B2 to H17, enter =sumif(B2:H17, "<500").

Go to the cell where you want to display the number of cells that contain numbers that fall under your condition

Enter the formulaEnter the formula =countif(range, condition). For example, if you want count of all numbers that are less than 500 in the range B2 to H17, enter =countif(B2:H17, "<500").

 This is one of the ways of using the sumif and countif functions

Loading