Formulas & functions
How a function works, with worked examples you can paste.
- Excel SUMIF Contains Number? Match Digits or ValuesYes—Excel’s SUMIF can sum rows where a text entry contains particular digits by using asterisks as wildcards, such as "*23*". If you…
- Excel SUMIF Between Dates: Formula and ExamplesTo sum values between two dates in Excel, use SUMIFS with a start-date criterion and an end-date criterion. For dates in A2:A100,…
- Excel SUMIF Between Two Dates: The Right FormulaTo sum values for dates within an inclusive start-to-end range in Excel, use SUMIFS, which supports more than one condition. With dates…
- Excel SUM vs SUMPRODUCT: Which Formula Should You Use?Use SUM to add numbers in a range; use SUMPRODUCT when you need to multiply corresponding values and add the results, or…
- Excel SUMIF After a Date: Formula and ExamplesTo sum values for dates strictly after a cutoff in Excel, use =SUMIF(A2:A100,">"&DATE(2024,1,1),B2:B100), where column A contains dates and column B contains…
- Excel SUMIF by Text Color: What Works and What Doesn’tExcel’s SUMIF function cannot directly test a cell’s text (font) color. To total values by color, use a filter and SUBTOTAL, record…
- Excel SUM Formula Returns 0? Causes and FixesIf an Excel SUM formula returns 0, first check whether its referenced cells contain real numbers and whether the formula points to…
- Excel SUM vs SUMIF: Which Function Should You Use?Use SUM to add numbers without applying a condition; use SUMIF to add numbers only when a specified condition is met. In…
- Excel SUBSTITUTE Formula: Replace Text in Cells PreciselyUse Excel’s SUBSTITUTE function to replace matching text in a cell: with the original text in A2, the text to find as…
- Excel SUBTOTAL with FILTER: How to Sum Visible RowsTo total values that remain visible after applying Excel’s built-in column filter, use SUBTOTAL on the original data range. With sales in…
- Excel SUBSTITUTE Double Quote: Formulas and ExamplesTo remove straight double quotation marks from a cell in Excel, use =SUBSTITUTE(A2,CHAR(34),"") when the text is in A2; for example, He…
- Excel Contact List Template: Build, Sort, and MaintainAn Excel contact list template is a workbook with clearly labeled columns for names, contact details, categories, and follow-up notes. In Microsoft…
- Excel Spreadsheet Sort by Highest Number: Steps & TipsTo sort an Excel spreadsheet by its highest number, click a cell in the number column and choose Data > Sort Largest…
- Excel Sort List Based on Another List: 3 MethodsTo sort one Excel list in the order specified by another, use SORTBY with XMATCH in Microsoft 365, or add a helper…
- Excel Sort Dates by Quarter: Methods and TipsYes. In Excel for Microsoft 365 on Windows, add a helper column that calculates each date’s quarter, then sort the entire table…
- Excel Sort and Filter by Multiple CriteriaIn Excel for Microsoft 365 on Windows, sort by several criteria with Data > Sort and add a level for each priority;…
- Excel Sort Dates by Month, Not by Year Across Multiple YearsTo sort Excel dates by month while ignoring the year, add a helper column with =MONTH(A2), fill it down, and sort the…
- Excel Sort A to Z: How Numbers Are SortedIn Excel, Sort A to Z sorts numeric values in ascending order—from the smallest number to the largest. Select a cell in…
- Excel Sort by Highest Number: A Clear Step-by-Step GuideTo sort numbers from highest to lowest in Excel, select a cell in the number column and choose Data > Sort Largest…
- Excel Sort a List by Another List: Reliable MethodsTo sort Excel rows into the order of a second list, use SORTBY with XMATCH, or add a helper column that assigns…
- Excel Simple Timesheet Template: Setup and FormulasTo make a simple timesheet in Excel, enter Date, Start, End, Break (minutes), and Hours in columns A:E, then use =MOD(C2-B2,1)*24-D2/60 in…
- Excel Show Numbers in K: Custom Formats and FormulasTo show Excel numbers in thousands with a K suffix while keeping the original values intact, select the cells, press Ctrl+1, choose…
- Excel Filter Drop-Down Shortcut: Open It QuicklyIn Excel for Microsoft 365 on Windows, select a cell in the filtered column’s header row and press Alt+Down Arrow to open…
- Excel Filter Shortcut: Turn Filters On and Open MenusIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for a data range. To open…
- Excel Sum Shortcut: Insert a SUM Formula FastIn Excel for Microsoft 365 on Windows, press Alt+= (Alt plus the equals key) to insert an AutoSum formula. Excel usually detects…
- Excel Filter Drop-Down Shortcut: Windows and MacIn Excel for Microsoft 365 on Windows, select a cell in the filtered column’s header and press Alt+Down Arrow to open its…
- Excel Sort and Filter Shortcuts: A Practical GuideIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for a data range. To sort…
- Excel Filter Shortcut: Turn AutoFilter On or Off FastIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. To filter the rows, then open a…
- Excel Filter Shortcut: Turn On and Open FiltersIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn column filters on or off. To open the filter menu for…
- Excel Shortcut for Removing a Filter: What WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter off or on; this removes the filter arrows and stops…