Formulas & functions
How a function works, with worked examples you can paste.
- COUNTIF in Excel: Count Yes or NoYes. Microsoft Excel has a COUNTIF function, and you can use it to count cells that contain “Yes,” “No,” or another value…
- COUNTIF Greater Than in Excel: Formula and ExamplesTo count values greater than a number in Excel, use =COUNTIF(B2:B20,">100"), assuming the values are in B2:B20 and the threshold is 100.…
- COUNTIF Formula for Attendance in ExcelTo count attendance marks in Excel, use =COUNTIF(B2:U2,"P"). If a student’s 20 session entries are in B2:U2 and “P” means present, the…
- COUNTIF Date Range in Excel: Formulas and ExamplesTo count dates between two limits in Excel, use COUNTIFS, which can test both the start and end dates; COUNTIF handles only…
- COUNTIF in Excel for Text: Examples and TipsYes. Excel’s COUNTIF function counts cells that match text, either as an exact match or by a pattern. For example, with text…
- COUNTIF for Text in Excel: Examples and WildcardsTo count cells containing a particular text value in Excel, use COUNTIF: with the values to check in A2:A8, the formula =COUNTIF(A2:A8,"Apple")…
- COUNTIF in Excel: Count a Range of ValuesTo count numbers within an inclusive range in Excel, use COUNTIFS with a lower and an upper limit: with the values 4,…
- COUNTIF Excel Formula for Text: Exact and Partial MatchesTo count cells containing text in Excel, use =COUNTIF(A2:A20,"apple") for an exact match, or =COUNTIF(A2:A20,"*apple*") when the text can appear anywhere in…
- COUNTIF Excel Text in Cell: Exact or Partial MatchesTo count cells that contain particular text anywhere in their contents, use =COUNTIF(A2:A100,"*apple*"); the asterisks allow any characters before or after “apple.”…
- COUNTIF Excel Contains Part of Text: Examples & TipsYes. In Excel, use COUNTIF with asterisks around the text you want to find: =COUNTIF(A2:A8,"*North*") counts cells in A2:A8 that contain “North”…
- COUNTIF in Excel: Exclude Text from a CountTo count nonblank cells while excluding any cell that contains a particular word, use =COUNTIFS(A2:A100,"<>",A2:A100,"<>*apple*"). Here, the values are in A2:A100; the…
- COUNTIF Excel: Count Duplicates, Repeats, and MatchesYes. In Excel, COUNTIF counts how many times a value appears: with items in A2:A100, enter =COUNTIF($A$2:$A$100,A2) beside the first item and…
- COUNTIF Excel: Count Cells That Contain Text in a RangeTo count cells that contain text in Excel, use =COUNTIF(A2:A100,"*"), replacing the range with your own. The asterisk is a wildcard: it…
- COUNTIF Excel by Text Match: Exact and Partial MatchesYes. In Excel, use COUNTIF to count cells that match text: with the values in A2:A9, =COUNTIF(A2:A9,"Apple") counts cells equal to Apple,…
- COUNTIF Equals Text in Excel: Examples and TipsTo count cells that equal a particular text value, use COUNTIF with the range and the text in double quotation marks. With…
- COUNTIF Distinct Values in Excel: Count Unique ItemsTo count distinct nonblank values in Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0), assuming the values are in A2:A100. If you specifically need…
- COUNTIF Duplicate Formula in Excel: Find DuplicatesTo flag every value that appears more than once in Excel, enter =COUNTIF($A$2:$A$100,A2)>1 beside the first value and fill down; it returns…
- COUNTIF(B:B,I2) in Excel: Meaning, Examples, and FixesIn Excel, =COUNTIF(B:B,I2) counts the cells in column B that match the value or counting criterion in cell I2. For example, if…
- COUNTIF Date in Excel: Count Dates, Days, and RangesTo count cells that contain a specific date in Excel, use COUNTIF with a date value as its criterion; to count every…
- COUNTIF Date Range in Excel: Count Dates Between Two DaysTo count dates between two limits in Excel, use COUNTIFS with a start-date condition and an end-date condition. For example, =COUNTIFS(B2:B100,">="&DATE(2025,1,1),B2:B100,"<"&DATE(2025,2,1)) counts…
- COUNTIF 0 in Excel: Count Zero Values and Blank CellsTo count cells that match zero in Excel, use =COUNTIF(A2:A20,0), replacing A2:A20 with your range. Be aware that blank cells can affect…
- COUNTIF in Excel: Formula, Examples, and Common FixesIn Excel, COUNTIF counts cells in a range that meet one condition. For example, with status labels in A2:A10, =COUNTIF(A2:A10,"Paid") counts cells…
- Count Unique Values Among Duplicates in ExcelTo count distinct nonblank values that appear at least twice in Excel, with the values in A2:A100, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,(A2:A100<>"")*(COUNTIF(A2:A100,A2:A100)>1)))),0). It returns one…
- COUNT Formula in Excel for Text and Numbers ExplainedTo count numeric values in cells A2:A100, use =COUNT(A2:A100); COUNT does not count text. To count text, use =COUNTIF(A2:A100,"*"), and to count…
- Excel COUNTIF Formula for Attendance Tracking SheetsTo count attendance in Excel, use =COUNTIF(B2:B31,"Present") when the attendance statuses are in cells B2:B31 and the exact status to count is…
- Count P in Excel: Formulas to Count Letters and MatchesTo count every p in the text in cell A2, use =LEN(A2)-LEN(SUBSTITUTE(LOWER(A2),"p","")). To count cells in a range that contain p at…
- Cost Savings Formula in Excel: Calculate and CompareTo calculate cost savings in Excel, subtract the new cost from the original cost: if the original amount is in B2 and…
- COUNT and COUNTIF in Excel: Formulas, Examples, TipsIn Excel, COUNT counts cells containing numbers, while COUNTIF counts cells that meet one condition. With numbers in A2:A100, use =COUNT(A2:A100); with…
- Correct Capitalization in Excel: Formulas and Quick FixesTo correct capitalization in Excel, use =PROPER(A2) to capitalize the first letter of each word, =UPPER(A2) to make all letters uppercase, or…
- Convert Numbers to K in Excel: Formats and FormulasTo show numbers as thousands with a “k” in Excel, select the cells, press Ctrl+1, choose Number > Custom, and enter #,##0.0,"k".…