How to count the numbers greater than 80 and less than 90 in excel

How to count the numbers greater than 80 and less than 90 in excel: First open the Excel table; then enter the formula in cell B1 as "=COUNTIF(A:A,">80")-COUNTIF( A:A,">=90")"; finally press the enter key.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Recommended: "Excel Tutorial"

1. As shown below, count the number of data in column A that is less than 90 and greater than 80;

2. Enter the countif formula in cell B1. Here we use the number greater than 80 and subtract the number greater than or equal to 90 to get the number less than 90 and greater than 80. , so the entered formula is =COUNTIF(A:A,">80")-COUNTIF(A:A,">=90");

3. Finally, press the enter key to get the statistical result to be 2. If you verify it again, you will find that the statistical result is correct, so you can use this formula for statistics.

The above is the detailed content of How to count the numbers greater than 80 and less than 90 in excel. For more information, please follow other related articles on the PHP Chinese website!