Formulas & functions
How a function works, with worked examples you can paste.
- Unable to Put a Filter in Excel? Common FixesIf you are unable to put a filter in Excel, select a cell in your data and choose Data > Filter; on…
- Trim Ends in Excel: Remove Extra SpacesTo trim spaces in Excel, enter =TRIM(A2) in another cell, replacing A2 with the cell containing your text. TRIM removes ordinary spaces…
- Track Sales in Excel With Formulas: A Practical GuideYes. In a sales log with quantity in column D and unit price in column E, enter =D2*E2 in F2 to calculate…
- Excel TODAY Formula for Days Between DatesTo calculate how many days have passed from a date in cell A2 to today, enter =TODAY()-A2 in another cell. Excel returns…
- Today’s Date in Excel: Number, Formula, and MeaningIn Microsoft Excel for Microsoft 365 on Windows, today’s date, November 3, 2026, is serial number 46329 in the standard 1900 date…
- VLOOKUP in Excel: Practical Tips for Reliable ResultsFor a reliable VLOOKUP in Excel, put the value you want to find in the first column of the lookup range, use…
- TEXTJOIN Formula in Excel With FILTER: How It WorksTo join only the values that meet a condition, combine Excel’s TEXTJOIN and FILTER functions. With names in A2:A7 and statuses in…
- Does VLOOKUP Work with Dates in Excel?Yes. VLOOKUP works with dates in Excel when the lookup date and the dates in the first column of the lookup range…
- Text Formula in Excel for Numbers: How to Use TEXTIn Excel, use the TEXT function to turn a number into text displayed in a format you choose. For example, if cell…
- Text Join and Filter in Excel: Formulas and ExamplesWith names in A2:A10 and their statuses in B2:B10, use =TEXTJOIN(", ",TRUE,FILTER(A2:A10,B2:B10="Open","No open items")) to return one comma-separated list of the names…
- TEXTJOIN Dates in Excel: Formulas and FixesTo join dates in Excel as readable text, wrap them in TEXT before combining them with TEXTJOIN. If actual Excel dates are…
- Text Filter in Excel With Multiple Criteria ExplainedTo filter text in Excel by multiple criteria, select your data, choose Data > Filter, open a column’s dropdown, and use Text…
- Excel Formula Symbols: What Each Operator MeansExcel formula symbols are operators and reference markers that tell Excel what to calculate or which cells to use. The main ones…
- Excel Tables and Formulas: How to Use Them TogetherYes. In Excel for Microsoft 365 on Windows, select your data and choose Insert > Table, then enter a formula in a…
- SUMIFS in Excel with Dates: Examples and TipsTo sum values for dates in Excel, use SUMIFS with the amount range first and the date range plus a date criterion…
- SUMIF Text Contains a Word in ExcelTo sum values when a cell contains a particular word, use SUMIF with asterisks around the word in its criteria. With descriptions…
- SUMIFS Between Two Dates in Excel: Formula & ExamplesTo sum values whose dates fall between two dates in Excel, use SUMIFS with the date column as a criteria range twice:…
- SUMIF Formula for Dates: Examples and Common FixesUse Excel’s SUMIF with a date as the criterion to add values for a specific date; use comparison criteria such as “on…
- SUMIF Positive Numbers in Excel: Formula and ExamplesTo sum positive numbers in Excel, use SUMIF with the criterion ">0". If the numbers are in B2:B10, enter =SUMIF(B2:B10,">0"); Excel adds…
- SUMIF a Date Between Two Dates in ExcelIf your dates are in A2:A100, the values to add are in B2:B100, and the start and end dates are in E2…
- SUMIF Excel Formula With Dates: Examples and FixesTo sum values for dates in Excel, use SUMIF for one date condition or SUMIFS for a start-and-end date range. With dates…
- Excel SUBTOTAL Formula With Filters: How It WorksTo total only the rows currently visible after filtering, use Excel’s SUBTOTAL function: if your amounts are in D2:D100, enter =SUBTOTAL(9,D2:D100) in…
- SUBSTITUTE Formula in Excel: Examples and UsesWith the text to edit in cell A2, use =SUBSTITUTE(A2,"-","") to remove every hyphen; if A2 contains INV-204-INV, the result is INV204INV.…
- Substitute Number for Letter in Excel: How to Do ItTo replace a letter with a number in Excel, use SUBSTITUTE: with the text to change in A2, enter =SUBSTITUTE(A2,"A","1") in another…
- SUBSTITUTE and REPLACE in Excel: Differences ExplainedIn Excel, use SUBSTITUTE to find specified text and replace it, or use REPLACE to change characters at known positions in a…
- Excel Spreadsheet Substitute: Find the Right ToolIf you need a substitute for an Excel spreadsheet, Google Sheets is the easiest choice for browser-based collaboration, while LibreOffice Calc is…
- VLOOKUP Between Two Excel Sheets: Step-by-StepTo use VLOOKUP between two sheets in the same Excel workbook, enter a formula on the sheet where you want the answer,…
- Split Numbers and Text in Excel With FormulasYes. With mixed values such as AB-123 in A2, Excel for Microsoft 365 can extract the digits with a formula that joins…
- Sort, Unique, Filter in Excel With Multiple CriteriaIn Excel for Microsoft 365, combine FILTER, UNIQUE, and SORT to return sorted distinct results that meet multiple criteria. For example, use…
- Sort List in Excel Formula: SORT, SORTBY, and MoreTo sort a list with a formula in Microsoft Excel for Microsoft 365, use SORT: with values in A2:A6, enter =SORT(A2:A6) in…