To count the number of cells that is greater than or less than between the list of the number or you can say prices as per this example in Excel, you can use the excel COUNTIFS function.
Please follow the steps given below and in the image:
- Select a blank cell where you want to display the result or follow the image.
- As per the example shown in the image, if you want to count the number of laptop that is greater then or less than $34500. in the range B4:B8, you would use the formula as per this example.
- Note : Make sure to change the range as per your list.
- Greater Than Type the formula : =COUNTIFS($A$4:$A$8,E4,$B$4:$B$8,”>”&F4) into the cell G4, where “range” is the range of cells you want to search, “E4” is the Item name, “F4” is the the price. G4 is the result cell where it display the number of laptop available that has the price greater than $34500.
- Less Than Type the formula : =COUNTIFS($A$4:$A$8,E4,$B$4:$B$8,”<“&F4) into the cell G4, where “range” is the range of cells you want to search, “E4” is the Item name, “F4” is the the price. G4 is the result cell where it display the number of laptop available that has the price less than $34500.
- That’s It 🙂
