Formulas & functions
How a function works, with worked examples you can paste.
- Excel TEXT Function for Dates: Formats and ExamplesTo turn an Excel date into formatted text, use =TEXT(A2,"mmmm d, yyyy"), assuming A2 contains a real date; for January 15, 2025,…
- Excel Text Filter Wildcards: How to Use ThemIn Excel for Microsoft 365 on Windows, text-filter wildcards let you match patterns: use * for any number of characters, ? for…
- Excel Text Filter Shortcuts: Search and Filter FasterIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off, then press Alt+Down Arrow in a column…
- Excel Text Filter Options: A Practical GuideExcel’s text filters let you show rows whose text matches a condition: choose options such as Equals, Begins With, Contains, or Does…
- Excel Text Filter for More Than Two Criteria: 3 WaysExcel’s standard Text Filters menu lets you combine only two conditions in its Custom Filter dialog. To filter for more than two…
- Excel Text Filter Multiple Values: How to Do ItTo filter for multiple text values in Excel, open the column’s filter menu and select each value you want to keep; Excel…
- Excel Text Comparison Formula: Exact vs. FlexibleTo compare two cells in Excel, use =A2=B2; it returns TRUE when their contents match and FALSE when they do not, without…
- Excel Table Not Showing Filter? Restore the DropdownsIf an Excel table is not showing filter arrows, click inside the table, open the Table Design tab, and turn on Filter…
- Excel Table Formulas Not Carrying Down? Fixes That WorkIf a formula in an Excel table is not carrying down, first confirm the data is an actual table, then check that…
- Excel Table Filter Out Duplicates: Keep One Copy SafelyYes—but Excel’s regular table filter does not have a built-in “show only unique rows” switch. To keep one copy and delete repeats,…
- Excel Table Filter: Show Unique Values and Remove DuplicatesIn an Excel table, open a column’s filter arrow to see its distinct values, then select the value or values whose rows…
- Excel Table Filters: Can You Filter Only Some Columns?Excel tables do not have a built-in setting to show filter arrows on only selected columns: the table’s Filter Button option shows…
- Excel Table Filter Multiple Values: Methods That WorkTo filter an Excel table for several values, open a column’s filter arrow, clear Select All, and check each value you want…
- Excel Table Filter by Multiple Colors: What WorksIn Excel for Microsoft 365 on Windows, a table’s color filter can show rows for one selected fill color, font color, or…
- Excel Table Filter by Text in Another Cell?Yes. To filter an Excel table using text in another cell, add a helper column with a formula that checks each row…
- Excel Table Filter Multiple Columns: How It WorksYes. In an Excel table, you can filter multiple columns at the same time by choosing a filter in one column and…
- Excel Table Filter by Cell Value: Steps, Tips, and FixesTo filter an Excel table by the value in a cell, right-click that cell and choose Filter > Filter by Selected Cell’s…
- Excel Table Different Formulas in the Same Column?Yes. An Excel table can contain different formulas in the same column, including a one-off formula in a particular row. However, Excel…
- Excel Table Formulas: Do They Fill Down Automatically?Yes. In Microsoft Excel for Microsoft 365 on Windows, a formula entered in a table column normally fills down the whole column…
- Excel Tables: Do New Rows Keep Formulas?Yes. In Excel for Microsoft 365 on Windows, a table normally carries a calculated-column formula into new rows, so you do not…
- Excel Table: Change a Formula in One Cell Only?Yes. To change a formula in just one Excel table cell, enter the replacement formula in that cell; if Excel fills it…
- Excel SUMPRODUCT vs PRODUCT: Differences, Examples, and UsesPRODUCT multiplies numbers together to return one product; SUMPRODUCT multiplies corresponding values in one or more arrays, then adds those products. Use…
- Excel SUMIFS With Values From a ListTo use Excel SUMIFS with values in a list, put the values in a criteria range and wrap SUMIFS in SUM. For…
- Excel SUMIFS: Multiple Criteria in the Same Column?Yes. In Excel, use SUMIFS with the same criteria range more than once when every condition must be true, or add separate…
- Excel SUMIFS With OR Criteria: Formulas and ExamplesExcel’s SUMIFS function does not provide a built-in OR operator between criteria: to match one condition or another, add separate SUMIFS results,…
- Excel SUMIF with Dates: Rules, Examples, and FixesTo sum values for a date or date range in Excel, use SUMIF with a date criterion; for a range with both…
- Excel SUMIFS Between Dates: Formula, Examples, and TipsTo sum values in Excel for dates from a start date through an end date, use =SUMIFS(C2:C100,A2:A100,">="&E2,A2:A100,"="&E2,A2:A100,"=E2": that would be treated as…
- Excel SUMIF Between Dates: Use SUMIFS CorrectlyTo sum values in Excel for dates between a start and end date, use SUMIFS with two conditions on the date range:…
- Excel SUMIF With a Date Range: Formula and ExamplesFor a total between two dates, use SUMIFS, which can apply both a start-date and an end-date condition: with dates in A2:A6,…
- Excel SUMIF Between Dates: Multiple Criteria ExplainedTo sum values in Excel for Microsoft 365 that fall between two dates and meet other conditions, use SUMIFS, not SUMIF: it…