Sum every nth column

sum every nth column in Excel

Learn how to sum every nth column (for example, every second, third, or fifth column) using the Excel SUMCOLUMNS function.

Sum every n rows

sum every n rows excel

Learn how to sum every n rows down in Excel using the SUMN_ROWS function or regular (SUM, OFFSET) functions.


median if formula in excel

Learn how to use the MEDIAN IF array formula to identify the middle number of values that meet specific criteria.

VLOOKUP multiple matches

vlookup multiple matches

This Excel guide will show you how to return and display multiple matches using the VLOOKUP function.