WHAT DOES THE FUNCTION CONTI IN EXCEL MEAN, HOW TO UNDERSTAND IT, AND HOW TO USE IT

It should be countif, right? is a conditional selection function. It's quite simple to figure it out for yourself, it's just to choose according to the conditions you specify.

It seems that there is no conti, only countif

The countif usage is as follows:

countif(range,criteria)

range is the range of cells in which you need to count the number of cells that meet the criteria.

criteria are criteria that determine which cells will be counted, and can be in the form of numbers, expressions, or text.

Examples: 1. Return the number of cells containing the value 12 =countif(data,12).

2. Return the number of cells with negative values =countif(data,"<0"）

3. Return the number of cells not equal to 0 =countif(data,"<>0"）

4. Return the number of cells greater than 5 =countif(data,">5"）

5. Return the number of cells equal to the content in cell A1 =countif(data,a1).

Don't have this function? Did you write it wrong? There is a countif function that indicates the number of items in the statistical area that meet the conditions.

In the excel function, $ represents an absolute reference.

Absolute Reference: An absolute cell reference in a cell (for example, $a$1) always references the cell at the specified location. If the position of the cell in which the formula is located changes, the absolute reference remains the same.

If you copy a formula with multiple rows or columns, the absolute reference will not be adjusted. By default, the new formula uses relative references, which need to be converted to absolute references. For example, if you copy an absolute reference from cell B2 to cell B3, it is the same in both cells, both are $a$1.

$ indicates the absolute referrer address.

1. Suppose there is a formula =B3*24 in unit C3

When copying the formula to unit d3, the formula becomes =c3*242, assuming that there is a formula =b$3*24 in unit c3, when copying the formula to unit d3, the formula becomes =b$3*243, $ can be expressed in ways including b$3, $b 3, $b$3, you can try the different effects of the formula after copying by yourself.

is the meaning of constraint, and $b$2 is an absolute reference to cell b2 and does not change with copying. Remove the $ before 2 and copy the formula downwards to ......When you remove the $ before b and copy it left and right, it will change to a c d

To put it simply, it means locking, $a is to lock column A, $3 is to lock the 3rd row, and $a$3 is to lock the 3rd row of column A.

Fixed meaning, that is, when you undrag the formula, if you add $, the letter after $ will not change.

Let's say you now type =b1 in the first cell

Then dragging vertically will become =b2 =b3 =b4 =b5, and dragging horizontally will become c1d1f1g1

But if you enter =b$1

Then when you drag it vertically, it will become =b$1 =b$1 =b$1 =b$1 The value is unchanged.

But when you drag horizontally, it becomes =c$1 =d$1 =e$1 =f$1

$ refers to the absolute address, if the formula is in the c3 cell, when you copy this function to other cells, such as the d10 cell, then the formula is changed to c10*24-$b$3*24, the previous one without adding $ will change, and the following one with $ will be the absolute address and will not change.

Absolute address means to copy the formula elsewhere. This doesn't change.

Refers to an absolute absolute reference, no matter how the formula is copied, it will not change, without adding $, and the formula changes with the change of the cell.

Meaning so.

First, in A1 to A4, find the rows that meet the conditions of 160000, and then sum the rows corresponding to the conditions in B1 to B4.

There are examples in the help. Study it yourself.

That is, the corresponding b1:b4 term is the sum of the corresponding b1:b4 terms greater than 160000.

sumif is a conditional summation function: the data that satisfies the condition is added.

It is understood as adding the data in column B corresponding to greater than 160,000 in column A.

Sum the commission for the purchase of a house with a price of more than 160,000.

It is to add up the numbers greater than 160,000 and sum them.

max is the maximum value for a set of data.

min is the minimum value.

The usage is also very simple.

First put the cursor on the target area, and then.

max(a2:b9)

Inside the parentheses are the areas that you have selected by yourself).

Returns the largest value in a set of values.

Syntax max(number1,number2,..number1, number2, .is the number from 1 to 255 that you want to find the maximum value from.

The description parameter can be a number or a name, array, or reference that contains a number.

Logical values and text representing numbers typed directly into the parameter list are counted.

If the parameter is an array or reference, only the numbers in that array or reference are used. Blank cells, logical values, or text in arrays or references are ignored.

If the parameter does not contain a number, the function max returns 0 (zero).

An error will occur if the parameter is an error value or if it is text that cannot be converted to a number.

If you want the calculation to include logical values in references and text that represent numbers, use the maxa function.

In fact, almost most of the functions in Excel help are explained in detail.

When using excel, select the cell, and then click Insert-Function, after selecting the corresponding function, there is a "Help about this function" in the dialog box, you can open the online help. In addition, Office provides detailed examples for you to learn and apply.

max is the maximum value.

Click fx to open the function window, and when selecting each function, there is a brief description of the function at the bottom.

Find the maximum.

For example, max(1,5,3)=5

max(a1:a5), that is, to find the maximum value in a1 a5, you enter =max() in the column, and then press and hold max, and click fx on the left, and it will help.

First look at the value of C38 in column A of the process quota data table, and if not, it shows that there is no set amount.

If there is, look for the rows of C38 in this worksheet, and take the value of the fourth column of the peer, which is column d, take it out and divide it by 1000, and then multiply by the value of column g of the peer.

AR in your formula is not necessary. Because you only take the fourth column, you can completely replace ar with d

If the Q4 value is the same as Q8, the counter is added by 1

It means an absolute quote.

Count $q$4: the number of occurrences of the value of q8 $q $4.

But it looks like you're having a problem with your range.