Get column totals

get column totals in Excel

To get column totals of a range that contain numeric values, use the TOTALCOL function or a custom formula that uses the MMULT function.

Get row totals

get row totals from a range in Excel

To get row totals of a range that contain numeric values, use the TOTALROW function or a custom formula with the MMULT function.

Add years to date

add years to date excel xdate

To add years to date in Excel, you can use the XDATE function instead of built-in functions like YEAR, MONTH, and DAY.