ExcelHow

Tag: Excel Countif

Excel nested if statements with ranges

Excel Examples, Excel Logical Functions

November 26, 2023
How to Rank data Based on the Number of Occurrences

Excel Examples

November 5, 2023
How to Get the First, 2nd or Nth Match Using Vlookup/Index/Match

Excel Examples

October 29, 2023
How to Count Cells between Two Dates with Multiple Criteria

Excel Examples

October 22, 2023
How to Extract a Unique List based on Criteria in Excel

Excel Examples

October 21, 2023
How to Count the Number of “Yes” / “No” in a Range

Excel Examples

July 10, 2023
How to Count the Number of Cells with non-zero value in Excel

Excel Examples

June 29, 2023
How to Countif across Multiple Worksheets

Excel Examples

May 25, 2023
How to Sum/Calculate Total Values with Duplicate Values Only Once in Excel

Excel Examples, Excel VBA

April 26, 2023
How to Concatenate Text based on unique values in Another Column in Excel

Excel Examples, Excel VBA

April 17, 2023
How to Count Numbers with Leading Zeros

Excel Functions, Excel VBA

April 8, 2023
How to Count or Sum Cells with Checked Box in Excel

Excel Examples

April 8, 2023
Find Missing Numbers in a Sequence in Excel

Excel Examples, Excel VBA

April 4, 2023
Count Attendance and Absence with COUNTIF function

Excel Examples

April 4, 2023
How to Sort a Column by Occurrence Count in Excel

Excel Examples

April 1, 2023
How to Count Cells that do not Contain Specific Text in Excel

Excel Examples, Excel VBA

March 26, 2023
Count Non-Contiguous Range using COUNTIF

Excel Examples

March 25, 2023
How to Replace Duplicates with Blank Cells in Excel

Excel Examples

March 13, 2023
How to Exclude Values from One Column Based on Values in Another Column in Excel

Excel Examples

March 9, 2023
How to Count Positive or Negative Numbers in Excel

Excel Examples

February 19, 2023