Formula Library
Utilities Formulas
General-purpose spreadsheet formulas for lookups, conditional formatting, and data manipulation.
Conditional Formatting Formulas
beginnerFormulas to use with conditional formatting for visual alerts in your budget spreadsheet.
=A2>B2 (to highlight when actual exceeds budget) SUMIFS with Multiple Criteria
intermediateSum values that match multiple conditions, like totaling expenses for a specific category within a date range.
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2) VLOOKUP for Category Matching
intermediateAutomatically look up and return information based on a category or transaction name.
=VLOOKUP(lookup_value, table_range, column_index, FALSE)