Formula Guides

COUNTIF Contains Partial Text Excel Use wildcards to count cells containing specific text. COUNTIF not Blank Excel Count cells that contain any value. COUNTIF with Multiple Criteria Excel Count rows that match multiple criteria at once. COUNTIFS between Two Dates Count records that fall between two dates. Excel Age Formula from Date of Birth Calculate age in full years from a birth date. Excel Formula Calculate Tax Calculate tax amount from a subtotal and tax rate. Excel Formula Check IF Cell Contains Word Check whether a cell contains a specific word. Excel Formula Combine First AND Last Name Join first and last name columns into one full name. Excel Formula Current Month Identify rows that belong to the current month. Excel Formula Days between Two Dates Calculate calendar days between a start and end date. Excel Formula Extract Text After Character Extract text that appears after a chosen character. Excel Formula Highlight Duplicates Highlight duplicate values with a COUNTIF rule. Excel Formula IF Date is Today Check whether a date equals today. Excel Formula Last Day of Month Find the last day of a month from any date. Excel Formula LEFT RIGHT MID Examples Extract text from the left, right, or middle of a cell. Excel Formula Percentage Change between Two Numbers Calculate percentage increase or decrease between two numbers. Excel Formula Percentage of Total Calculate one value as a percentage of the total. Excel Formula Rank Without Ties Create unique ranks even when values are tied. Excel Formula Running Total Create a running total that updates down the column. Excel IF AND Formula Multiple Conditions Combine IF and AND to test several requirements at once. Excel IF Cell Contains Text Then Return Value Return a value when a cell contains a specific word. Excel IF Formula with 3 Conditions Return a result only when three conditions are all true. Excel Remove Spaces Formula Remove extra spaces from imported or messy text. Excel SUMIF by Month Sum revenue for a specific month using date boundaries instead of manual filters. Excel SUMIF with Multiple Criteria Same Column Add values when one column can match several allowed criteria. Google Sheets COUNTIF Color Count colored rows in Google Sheets with a helper column. Google Sheets Date Formula Today Minus Date Calculate days elapsed since a date in Google Sheets. Google Sheets Formula Gross Profit Margin Calculate gross profit margin in Google Sheets. Google Sheets Formula Send Email IF Condition Flag rows that should trigger an email workflow. Google Sheets IF Formula with Multiple Conditions Use Google Sheets IF with multiple conditions. Google Sheets SUMIF Contains Text Sum Google Sheets rows where a text cell contains a keyword. Google Sheets XLOOKUP Example Learn the basic XLOOKUP pattern in Google Sheets. IF Formula Date is Past Due Excel Flag dates that are already past due using TODAY. IF Formula with Text Excel Use IF to return different results based on text values. INDEX MATCH Return Multiple Values Return all matching rows for one lookup value. INDEX MATCH Vs VLOOKUP See when INDEX MATCH is better than VLOOKUP. INDEX MATCH with Multiple Criteria Excel Use INDEX MATCH with two or more lookup criteria. Nested IF Formula Excel Example Build a nested IF formula for tiered results such as grades. SUMIF Across Multiple Sheets Excel Combine matching totals from several Excel sheets. SUMIF between Two Dates Excel Sum rows that fall inside a start and end date range. SUMIF Blank Cells Excel Sum values where the matching criteria cell is blank. SUMIF Greater Than Zero Excel Sum only positive numbers while ignoring zero and negative values. SUMIF not Equal to Excel Sum everything except one excluded category or label. SUMIF with OR Condition Excel Sum rows that match one of several possible values. SUMIF with Wildcard Excel Use wildcards to sum rows containing a word or phrase. VLOOKUP between Two Sheets Excel Use VLOOKUP to pull values from another sheet. VLOOKUP Return Multiple Columns Return several columns from one VLOOKUP formula. VLOOKUP with IF Condition Excel Use IF to evaluate the result returned by VLOOKUP. XLOOKUP IF not Found Return Blank Return a blank cell when XLOOKUP finds no match. XLOOKUP with Multiple Criteria Excel Use XLOOKUP when one lookup value is not enough.