Top "Countif" questions

COUNTIF is an Excel function which allows for the counting of values in a range where the values meet a criterion.

How to use VLOOKUP result as COUNTIF criteria

I want to be able to determine how many times a person's particular ID (e.g. #123) has appeared in a …

excel excel-formula vlookup worksheet-function countif
Count number of cells in a range that match the content of a different cell

I am trying to use COUNTIF in Excel to find how many items in a range match the contents of …

excel worksheet-function countif
How do I combine COUNTIF with OR

In Google Spreadsheets, I need to use the COUNTIF function on a range with multiple criteria. So in the table …

regex google-sheets countif google-sheets-formula array-formulas
Excel countif date in cell is greater than or equal to date in another cell

This has been killing me for a while now. I just need to count a cell if the date in …

excel excel-2007 countif
Google Sheets COUNTIF / COUNTIFS formulas based on multiple criteria

I'm looking for some expertise with formulas. I've got a raw data source and need to be able to summarise …

google-sheets countif formulas
How to count cells that only contain the VALUE 0 and not the result of a formula?

For the following sheet: A 1 0 2 0 as formula result 3 0 4 0 as formula result 5 0 as formula result 6 blank 7 0 How do I count only …

excel excel-formula formula countif
Excel Countif Date in column A is greater than column B

Columns A and B both have dates. If the date in column A is greater than the date in the …

excel date countif
How to do countIf() in Oracle

How do I select a variable which gives an output the same as the excel function: COUNTIFS(A1:D1,"<25", …

sql oracle countif
Countifs in Excel with list of names as criteria

I'm trying to write a countifs formula in Excel using a list of names. The following example illustrates what I …

excel countif
Count occurrences of values

I have a column of text values with repeated values. I want to create a new column of unique values (…

excel count excel-formula pivot-table countif