Combine the Criteria in the Function Formula

Combine the Criteria in the Function Formula

To illustrate the purpose of the title above, we illustrate through the following picture. To apply it, please create it first in Excel like the table in the picture.

In the picture above, the table on the left is the raw data table, while the table on the right is the data output table that we have to process based on the data on the right. How, here we will use the SUMIF Function Formula and we will combine (combine) the criteria in the function formula.


http://www.excel-foraccounting.com/combine-criteria-function-formula.html

Looking for Maximum and Minimum Values

Looking for Maximum and Minimum Values

The following excel formula trick is how to find a value, maximum and minimum value in a range of values. This trick can be used by school teachers who are accustomed to processing student data related to the highest and lowest grades of students, or by anyone who wants to determine the lowest and highest data values ​​as analysis material, such as sales value and so on.

For more details, how can I illustrate this case as shown in the following table.

http://www.excel-foraccounting.com/maximum-minimum-values.html