How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Google Sheets COUNTIF With Multiple Criteria ExplainedGoogle Sheets’ COUNTIF function accepts one condition; to count cells that meet multiple conditions at the same time, use COUNTIFS. For alternatives…
- Google Sheets COUNTIF by Text Length: Formulas & TipsTo count entries that are exactly five characters long in Google Sheets, use =SUMPRODUCT(--(LEN(A2:A100)=5)), assuming the values are in A2:A100. Change 5…
- Google Sheets COUNTIF With Multiple Ranges: How It WorksGoogle Sheets’ COUNTIF function accepts one range at a time, so to count matching values across separate ranges, add together one COUNTIF…
- Google Sheets COUNTIF Format: Syntax, Criteria, ExamplesIn Google Sheets, COUNTIF uses the format =COUNTIF(range, criterion) to count cells that meet one condition. For example, if order statuses are…
- Google Sheets COUNTIF for Empty CellsTo count empty cells in Google Sheets, use =COUNTIF(A2:A100,""), replacing A2:A100 with your range. The empty-string criterion counts cells Sheets treats as…
- Google Sheets COUNTIF Criteria: Syntax and ExamplesIn Google Sheets, a COUNTIF criterion is the condition that tells the function which cells to count. Use =COUNTIF(range, criterion): for example,…
- Google Sheets COUNTIF Contains: Match Text AnywhereTo count cells in Google Sheets that contain a particular text anywhere, use =COUNTIF(A2:A100,"*apple*"). The asterisks are wildcards: they let any characters…
- Google Sheets COUNTIF: Find Cells with Partial TextYes. In Google Sheets, use COUNTIF with asterisks around the text you want to find: =COUNTIF(A2:A8,"*tea*") counts cells in A2:A8 that contain…
- Google Sheets COUNTIF Contains Text: Formula and ExamplesYes. In Google Sheets, use =COUNTIF(A2:A100,"*text*") to count cells in A2:A100 that contain “text” anywhere; the asterisks are wildcards, and COUNTIF does…
- Google Sheets COUNTIF by Color: Practical Ways to CountGoogle Sheets’ COUNTIF cannot count cells by fill color directly: it evaluates cell values against a criterion, not formatting. To count colored…
- Google Sheets COUNTIF: Count Checked Checkbox CellsTo count checked checkboxes in Google Sheets, use =COUNTIF(B2:B20,TRUE), replacing B2:B20 with the cells containing your checkboxes. Standard checkboxes store checked as…
- Google Sheets COUNTIF: Count Non-Empty Cells in a RangeIf your entries are in A2:A100, count cells that are not empty in Google Sheets with =COUNTIF(A2:A100,"<>"). The criterion "<>" means “not…
- Google Sheets COUNTIF Between Two Values: A Clear GuideTo count numbers between two limits in Google Sheets, use COUNTIFS with the same range twice: if the values are in A2:A100…
- Google Sheets COUNTIF by Cell Color: What Actually WorksNo—Google Sheets’ COUNTIF function cannot count cells by their fill color. It checks cell values against a criterion, not formatting; to count…
- Google Sheets COUNTIF: Count Cells That Contain TextYes. In Google Sheets, use COUNTIF with asterisks around the text to count cells that contain it anywhere: if the text is…
- Google Sheets: Count Weekdays Between DatesYes. In Google Sheets, use =NETWORKDAYS(A2,B2) to count Monday-through-Friday workdays between the start date in A2 and the end date in B2,…
- Google Sheets: Count Unique Values in a Column EasilyTo count distinct values in a Google Sheets column, use =COUNTUNIQUE(A2:A) when the data starts in A2. To count only nonblank entries…
- Google Sheets COUNTIF: Count Cells Containing TextWith the text to check in A2:A100, count cells containing a word or phrase anywhere in the cell with =COUNTIF(A2:A100,"*apple*"). The asterisks…
- Google Sheets COUNTIF: Count Yes AnswersTo count cells that contain the answer Yes in Google Sheets, use =COUNTIF(A2:A100,"Yes"), replacing A2:A100 with your response range. COUNTIF counts matching…
- Google Sheets: Count Dropdown Values in a Column EasilyTo count how many times a particular dropdown choice appears in Google Sheets, use =COUNTIF(B2:B100,"Approved"), replacing the range and choice with your…
- Google Sheets Count If Not Blank: Formulas and FixesTo count cells that are not blank in Google Sheets, use =COUNTA(A2:A100), replacing the range with your own. If cells contain formulas…
- Google Sheets: Count Checked Checkboxes with COUNTIFTo count checked checkboxes in Google Sheets, use =COUNTIF(B2:B20,TRUE), replacing B2:B20 with the cells that contain your checkboxes. A checked standard checkbox…
- Google Sheets: Count Cells by Highlight ColorGoogle Sheets does not have a built-in COUNTIF function that counts cells just because they are highlighted with a fill color. To…
- Google Sheets: Count Dates in a Month with COUNTIFSTo count dates in a particular month in Google Sheets, use COUNTIFS with a start date and the first day of the…
- Google Sheets: Count Cells With Specific Text in a RangeTo count cells that exactly match text in Google Sheets, use =COUNTIF(A2:A100,"Paid"); to count cells that contain the text anywhere, use =COUNTIF(A2:A100,"*Paid*").…
- Google Sheets: Count Cells With a Specific Dropdown ValueTo count cells that contain a particular Google Sheets dropdown choice, use COUNTIF. For example, if dropdowns are in B2:B100, =COUNTIF(B2:B100,"Approved") counts…
- Google Sheets: Count Cells That Contain Text ValuesTo count cells containing text in Google Sheets, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. It counts text entries, including text that…
- How to Create a Company Email Signature in OutlookCreate a company signature in Outlook by opening the signature settings for the version you use, adding your approved contact and branding…
- How to Create a Cool Signature in OutlookTo create a cool Outlook signature, keep it easy to scan: use your name, role, one or two useful contact details, and…
- Create a Cursive Signature in Outlook: Step-by-StepTo create a cursive signature in Outlook, add either script-style text or a picture of your handwritten signature in Outlook’s signature settings,…