This will display the value as per your wish. SUM function returns the sum of the values supplied. From this we need to find what the total production qty and total salary is.
The SUMIF function below two arguments sums values in the range A1A5 that are less than or equal to 10.
Sum function is another mathematical function that is used for summing up the selected numbers whether they are decimals or whole numbers. In simple words with the SUM function you can calculate the sum of a list of values you can directly input value into the function or refer to a range of cells. SUM can handle up to 255 individual arguments. The SUMIF function returns the sum of cells in a range that meet a single condition.