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.

Get first name from name

get first name from full name in Excel

Learn how the get the first name from a name using regular (LEFT, FIND) and user-defined (TextLeft, ExtractWord) functions.