Rounding numbers to a specified decimal place or nearest major unit
Sometimes you don’t require numbers to the nth level of detail, especially if you want to avoid Excel’s ###### symbol or having to resize your columns
Sum data based on multiple criteria with SUMIFS
The SUMIFS function is probably one of the most useful functions with Excel that you will ever use. Rather than summing data by a fixed range, the SUMIFS function will allow you to sum values from a column or row based on the criteria in a corresponding column or row.