The specific solution steps are as follows:

1. Taking this table as an example, it is necessary to count the number of people who scored greater than (including equal to) 80 points in both mathematics and English.

2. Enter =COUNTIFS(C2:C22, "gt;=80", D2:D22, "gt;=80") in cell J5.

3. After pressing Enter, you will see that the result is 3. From the table, we can also see with our eyes that the three marked people meet the conditions.

4. So what does this function mean? COUNTIFS(C2: C22, "gt; = 80", D2: D22, "gt; = 80") is actually basically the same as the countif function. There is one more data column and one more condition in the function, which means that two conditions are met at the same time. number of people.

Extended information:

In 1982, Microsoft launched its first electronic spreadsheet software-Multiplan, which was a great success on the CP/M system, but in MS -On DOS systems, Multiplan lost to Lotus 1-2-3. This event prompted the birth of Excel, just like Excel development codename Doug Klunder: Do what Lotus 1-2-3 can do, and do it better. In 1985, the first Excel was born, which was only used for Mac systems;

In November 1987, the first Excel for Windows systems was also produced (it was directly bundled with the Windows environment and in Mac The version number is 2.0). Lotus 1-2-3 has been unable to be applied to Windows systems. By 1988, Excel sales exceeded Lotus, making Microsoft the leading position among PC software vendors.

This incident contributed to the replacement of the dominant player in the software kingdom. Microsoft consolidated its position as a strong competitor and found the direction to develop graphics software. About every two years since then, Microsoft will launch a new version to expand its advantages. Currently, the latest version of Excel is 16, also known as Microsoft Office Excel 2016.

In the early days, Excel became the target of trademark law because it had the same name as a software called Excel sold by another company. After a trial, Microsoft was required to use the name Microsoft Excel in its official documents and legal documents. to name this software. However, as time went by, this practice gradually disappeared.

Although Excel provides a large number of user interface features, it still retains the features of VisiCalc, the first electronic spreadsheet software: rows and columns form cells, data, data-related formulas or other An absolute reference to the cell is saved in the cell.

Excel is the first spreadsheet software that allows users to customize the interface (including fonts, text attributes and cell formats). It also introduces the "intelligent recalculation" function. When cell data changes, only the data related to it will be updated, while the original tabulation software can only recalculate all data or wait for the next instruction. At the same time, Excel also has powerful graphics functions.

Reference materials: Baidu Encyclopedia: Excel

Word Alliance: Several Excel skills worth collecting