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.

Sum every nth row

sum every nth row in Excel

Learn how to sum every nth row (for example, every second, third, or fifth row) in Excel using the SUMN or SUMPRODUCT function.

Count numbers by nth digit

Count numbers by nth digit in Excel

To count numbers where the nth digit is a given number, use the Excel COUNTDIGITS function or a formula based on MID and IFERROR functions.