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