Excel Formula Examples and Tutorials
Browse Excel formula guides for SUM, SUMIF, COUNTIF, IF, VLOOKUP, XLOOKUP, and spreadsheet tasks.
Excel formulas guides
Excel SUM Function: Add Numbers and RangesUse Excel SUM to total cells and ranges, with a small sales example and checks for common totaling errors.
Excel SUMIF: Sum Values That Match One ConditionUse SUMIF to add values for matching rows, with an example that totals sales for the North region.
Excel SUMIFS: Sum Values With Multiple ConditionsUse SUMIFS to total spreadsheet values only when every specified condition is met.
Excel COUNTIF: Count Cells That Match a ConditionUse COUNTIF to count cells matching a text label, number, or comparison condition.
Excel COUNTIFS: Count Rows Matching Multiple ConditionsCount rows only when every specified condition matches, using a region and payment-status example.
Excel IF: Return a Value When a Condition Is TrueUse IF to test a condition and return one result when it is true and another when it is false.
Excel IFERROR: Replace a Formula Error With a Useful ResultUse IFERROR to show a chosen fallback when a formula returns an error, while preserving valid results.
Excel VLOOKUP: Find a Value in a TableUse VLOOKUP with an exact match to find a key in the first column and return a corresponding value.
Excel XLOOKUP: Flexible Exact-Match LookupsUse XLOOKUP to search a lookup range and return a corresponding value, including from columns on either side.
Excel Percentage Change Formula With an ExampleCalculate percentage change in Excel by comparing a new value with an original value and format the result as a percentage.