2. The conditional summation function SUMIF is to sum the contents that meet the conditions, for example =SUMIF(H2:H7, ">; =60 ",H2:H7), that is, the data greater than or equal to 60 in cells H2 to H7 are added.
3.IF function, which is a logical judgment function. The simple form of the IF function is: IF (if the content is true, the first value is returned, otherwise other values are returned).
Extended data:
Excel functions * * * have 1 1 classes, which are database functions, date and time functions, engineering functions, financial functions, information functions, logical functions, query and reference functions, mathematical and trigonometric functions, statistical functions, text functions and user-defined functions. When you need to analyze whether the values in the data list meet certain conditions, you can use the database worksheet function.
The engineering worksheet function is used for engineering analysis. Most of these functions can be divided into three types: functions for dealing with complex numbers, functions for numerical conversion between different digital systems (such as decimal, hexadecimal, octal and binary), and functions for numerical conversion in different measurement systems.
Baidu Encyclopedia -excel Function