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.
There are many instances where Excel users may want to return the first or last day of the month from a cell referencing a date. This can include creating additional mapping so that formulas work using one date as a criteria rather than a ranges of dates, and being able to summarise data in a more simple way.
A list of over 100 Excel functions and formulas to help you create better spreadsheets. These functions have been categorised to for ease of use.