Excel formulas for jobs you actually type into Google.
Percent of total, two-criteria lookup, working days, text between delimiters, running totals, and other worksheet tasks.
Percentage of total
Excel Formula for Percentage of Total
Divide the row amount by the column total and lock the total with $ so the formula copies cleanly down the sheet.
Read guide- Two-criteria lookupExcel Lookup With Two Criteria FormulaMatch two columns at once, such as region and product, then return a price or status from the same row.
- Working daysExcel Working Days Between Dates FormulaNETWORKDAYS counts weekdays from a start date to an end date and can skip a holiday range.
- Text between delimitersExcel Extract Text Between DelimitersUse TEXTBEFORE and TEXTAFTER on Microsoft 365, or MID and FIND on older Excel, to take the middle token of a code.
- Running totalExcel Running Total Formula That CopiesAdd this row to all amounts above it. Lock the start of the range and leave the end relative so the total grows as you copy.
- Age from birth dateExcel Age From Date of Birth FormulaDATEDIF with unit Y returns whole years between a birth date and today, which is the usual age in years.
- Last non-empty cellExcel Last Non-Empty Cell in a ColumnSearch from the bottom for the last nonblank cell so dashboards always show the newest entry.
- Text to dateExcel Convert Text Dates to Real DatesExcel cannot subtract or filter text that only looks like a date. Split the parts and rebuild with DATE.
- Sum if this monthExcel Sum Amounts If Date Is This MonthBuild a start and end date for the current month, then SUMIFS amounts whose dates fall in that window.
- Highlight duplicatesExcel Formula to Flag Duplicate ValuesCOUNTIF on the whole column tells you how many times this value appears. A helper column is easier to audit than conditional formatting alone.
- Domain from emailExcel Extract Domain From Email FormulaEverything after @ is the domain. TEXTAFTER is the short form; FIND and MID work in older Excel.
Need this on your columns?
Describe the sheet. Copy an Excel formula written for those ranges.