Build the right Excel formula in plain English
Stop searching forums for the right syntax. Choose what you want to do, type your cell references, and copy a formula that works, with a plain-English explanation and a version for older Excel.
- Lookups: XLOOKUP, INDEX/MATCH and VLOOKUP, exact or approximate, with a friendly "Not found" message.
- Totals with conditions: SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS and MINIFS with text, numbers, dates, "contains", "between" and blank conditions. The tricky quotes and & signs are done for you.
- IF logic: Single tests and grade/band tables using IFS, nested IF or LOOKUP.
- Text, dates and maths: Split names, tidy messy text, working days with UK bank holidays, UK financial year labels, % change, VAT, margin, rank and running totals.
- Duplicates and lists: Flag duplicates, count unique values, UNIQUE and FILTER.
Every formula was tested in a real spreadsheet with sample data to make sure it gives the right answer.