Formulas & functions
How a function works, with worked examples you can paste.
- Excel Delete Duplicates: How to Keep the Right RowsTo delete duplicate rows in Excel for Microsoft 365 on Windows, select your data, go to Data > Remove Duplicates, choose the…
- Excel Delete Every X Rows: Safe Methods and FormulasYes. In Microsoft Excel for Microsoft 365 on Windows, add a helper column to mark every xth data row, filter for those…
- Excel Date Filter Multiple Criteria: Practical MethodsTo filter dates in Excel by multiple criteria, turn on AutoFilter, open the date column’s dropdown, and choose Date Filters > Between…
- Excel Data Validation for a Unique ListYes—but Excel’s Data Validation list does not automatically remove duplicates from its source. In Microsoft 365 for Windows, create a distinct list…
- Excel Data Validation Lists Based on FormulasYes. In Excel for Microsoft 365 on Windows, you can base a Data Validation list on formula-generated choices. The reliable method is…
- Excel Data Filter Multiple Criteria: Practical MethodsTo filter Excel data by multiple criteria, turn on Data > Filter, then set conditions in the column dropdowns: conditions in different…
- Excel Custom Number Format: Round Values to ThousandsTo display Excel values rounded to the nearest thousand without changing the stored numbers, apply the custom number format #,##0,. Select the…
- Excel Custom Number Format: Round Values to MillionsYes. In Excel for Microsoft 365 on Windows, apply the custom number format #,##0,,"M" to display numbers in millions rounded to the…
- Excel Custom Number Format: Add Text at the Far LeftYes. In Excel for Microsoft 365 on Windows, use a custom number format with an asterisk followed by a space: "Status:"* #,##0.00.…
- Excel Counting Unique Values in a List: Formulas and TipsTo count distinct, nonblank values in an Excel list, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0), replacing A2:A100 with your range. In Microsoft 365 for Windows, this…
- Excel COUNTIFS With Multiple Criteria in One RangeYes. Excel’s COUNTIFS can apply more than one condition to the same range by repeating that range for each condition: =COUNTIFS(A2:A10,">=10",A2:A10,"=10",A2:A10,"<=20") In…
- Excel COUNTIFS Multiple Criteria in the Same ColumnYes. In Excel, use COUNTIFS with the same range repeated for each condition; the conditions are combined with AND. For example, with…
- Excel COUNTIF Without Duplicates: Count Unique ValuesTo count distinct, nonblank values in Excel 365, use =COUNTA(UNIQUE(FILTER(A2:A100,A2:A100<>""))) when the values are in A2:A100. COUNTIF alone counts matching cells, including…
- Excel COUNTIF for a Number Range: Formula and ExamplesTo count numbers between two limits in Excel, use COUNTIFS, which applies both a lower and an upper condition to the same…
- Excel COUNTIF for Red Text: What WorksExcel’s COUNTIF function cannot count cells by red font color: COUNTIF checks cell values, not formatting. To count red text, use a…
- Excel COUNTIF for Red Text: Methods That Actually WorkCOUNTIF cannot directly count cells by red font color: it evaluates cell values, not formatting. To count red text in Excel, count…
- Excel COUNTIF Over a Number: Greater Than CriteriaTo count numbers greater than a value in Excel, use =COUNTIF(A2:A100,">50"), replacing the range and 50 with your own data and threshold.…
- Excel COUNTIF for Numbers in Cells: Examples and FixesTo count cells that equal a number in Excel, use =COUNTIF(B2:B20,25), replacing the range and 25 with your own. For a number…
- Excel COUNTIF for Text: Exact and Partial MatchesTo count cells that match text in Excel, use COUNTIF: with the text values in A2:A10, =COUNTIF(A2:A10,"Apple") counts cells equal to Apple,…
- Excel COUNTIF Not a Number? Count Text, Blanks, and ErrorsCOUNTIF can count cells that match a criterion, but it does not have a built-in criterion meaning “is not a number.” To…
- Excel COUNTIF: Count Cells That Aren’t ErrorsCOUNTIF does not have a reliable criterion for “is not an error.” To count cells that contain no error, with data in…
- Excel COUNTIF Equal to a Number: Formula and ExamplesTo count cells equal to a number in Excel, use =COUNTIF(B2:B10,100), replacing the range and number with your own. COUNTIF counts cells…
- Excel COUNTIF With Dates: Criteria, Ranges, and ExamplesTo count dates in Excel, use COUNTIF with a date value for an exact match, or join a comparison operator to a…
- Excel COUNTIF: Count Values Greater Than a Number EasilyYes. To count values greater than a number with Excel COUNTIF, use a criterion such as ">100". If the values are in…
- Excel COUNTIF for Dates Between a RangeTo count dates between two boundaries in Excel, use COUNTIFS, which applies both a start-date and an end-date condition: with dates in…
- Excel COUNTIF Dates Within a Month: Formula and TipsTo count dates in a particular month in Excel, use COUNTIFS with a start date and an exclusive end date. If your…
- Excel COUNTIF: Find Text From a ListTo count cells that contain any text from a list in Excel for Microsoft 365, use =SUM(COUNTIF(A2:A10,"*"&C2:C4&"*")), where A2:A10 contains the text…
- Excel COUNTIF: Count Dates Between Two DatesTo count dates in a column that fall between a start date and an end date, use COUNTIFS, which applies both date…
- Excel COUNTIF and SUMIF With Dates: Practical ExamplesTo count or sum rows by date in Excel, use COUNTIF or SUMIF with a date criterion; for a period such as…
- Excel COUNTIF by Text Color: Options and WorkaroundsExcel’s COUNTIF function cannot count cells by font or text color: its criteria test cell values, not formatting. To count colored text,…