From this we need to find what the total production qty and total salary is. Use the SUM function in Excel to sum a range of cells an entire column or non-contiguous cells. This will automatically calculate the sum of numbers and display in the formula applied cell.
You can add individual values cell references or ranges or a mix of all three.
AutoSum is a built-in function within Excel. The SUM function adds values. The SUMIF Excel function is categorized under Math and Trigonometry functions. We can use the function to find out the total cost of the event.