The ROUNDDOWN function

Rounds the input value down to the nearest number based on the number of decimal places indicated, with 0 returning a whole number

The ROUNDUP function

Rounds the input value up to the nearest number based on the number of decimal places indicated, with 0 returning a whole number

The ROUND function

Rounds the input value up or down to the nearest number based on the number of decimal places indicated, with 0 returning a whole number

The SUMPRODUCT function

Returns the sum of the products of corresponding array components

The SUMIFS function

Adds the cells in a range that meet multiple criteria

The SUM function

Adds its arguments