The countif tag has no wiki summary.

**5**

votes

**2**answers

2k views

### Excel: Counting number of MAX values in a range

I am using Excel 2003 (version limited due to corporate policy) to keep a score sheet:
A B C D
1 Round | Rita | Sue | Bob
------+------+-----+-----
2 1 | 5 | 3 | 4
3 ...

**4**

votes

**1**answer

542 views

### Excel countif doesn't work with numbers

in the following example you get output '0' for a strange reason. Can someone explain why this occurs and what I can do about it? (The format of the cells is "text")
rows A:A
---------
1
11
111
22
2
...

**3**

votes

**2**answers

68 views

### Count first occurrence of one criterion based on a second criterion

I am trying to write an excel formula (or formulas) to count the first occurrence of a value in a given year for each Person in my table. I've searched for related questions on Superuser to no avail. ...

**2**

votes

**2**answers

3k views

### check two conditions in two different columns in excel and count the matches

I've trying to create a Error Log to help me analyse my mistakes. So for simplicity, lets assume I have two columns "Type of Question" - with values SC,RC,CR and another column that indicates whether ...

**2**

votes

**3**answers

3k views

### Include an OR condition in a COUNTIF?

This question has been asked before and the answer always seems to be to add together two COUNTIFs. This is fine for most applications, but won't work for me.
I have a column that can contain 0, 1 or ...

**2**

votes

**2**answers

461 views

### Excel COUNTIF Statement

A---------------------------B
2012-04-12 12:52...... FC
2011-06-24 10:07...... FC
2011-06-24 10:08...... FC
2012-04-17 0:00 ...... COH
2012-04-12 12:22 ...... FC
2011-06-24 ...

**2**

votes

**1**answer

709 views

### Count value between 2 date ranges

I was able to count how many occurrences of dates between 2 date ranges, however now I having difficulty counting how many times Yes occurs between 2 date ranges.
this formula works for counting how ...

**1**

vote

**1**answer

888 views

### How to use countif, sumif across two sheets where the logical test is an equivalency?

I am building a simple sum sheet that relies on a conditional but I can't seem to get COUNTIF/SUMIF to work for me.
To sum, I have two sheets, one with a few hundred lines of records including an ...

**1**

vote

**2**answers

164 views

### Excel: Reference Dropdown Cell in Countif Formula

I'm trying to substitute text in an excel formula with a cell reference to the text in a dropdown.
First formula that yields the correct answer is:
=(SUM(COUNTIFS('LP - All ...

**1**

vote

**2**answers

34 views

### Count unique values in column B with respect to column A

I have two columns in Microsoft Excel, A and B. The input is displayed below
A B
ABC 1
ABC 1
ABC 2
ABC 2
ABC 2
DEF 1
DEF 3
DEF 3
CDE 1
CDE 2
CDE 3
CDE 4
I ...

**1**

vote

**1**answer

639 views

### excel countif filtered by style

I have an Excel spreadsheet and I'm trying to count rows in a column based on a style applied to some cells in the column. Is there a simple way to do this?

**1**

vote

**1**answer

33 views

### How to count unique numbers based on month?

Column A include a list of numbers, some are duplicated
Column B include a list of numbers from 1-12 that represent the months
I need to count the unique numbers in column A where the month in ...

**1**

vote

**0**answers

33 views

### Custom function COUNTIFUNIQUES in Excel [duplicate]

Possible Duplicate:
Excel: how to count number of distinct values in a range?
I would like to create a custom function COUNTIFUNIQUES that extends the functionality of COUNTIFS.
Here is an ...

**0**

votes

**4**answers

238 views

### Excel COUNTIF Slow

I'm having an odd issue in excel that I haven't run into before. I have an excel sheet that I'm attempting to pull some specific records from, requiring that I know of duplicates. I am using a COUNTIF ...

**0**

votes

**2**answers

76 views

### Excel countifs criteria neither this nor that

Im trying to make a criteria for COUNTIFS such that the value of the cell is neither "pass" nor "fail" nor blank. How can I do this? I dont think "<>pass<>fail<>*" works
Since someone wanted ...

**0**

votes

**1**answer

793 views

### How can I run SUMIF or COUNTIF with two Conditions?

I recently got some great help with SUMIF and COUNTIF and ended up with the following, working formulas;
=SUMIF(REC!$F:$F,$C2,REC!$G:$G)
=COUNTIF(REC!$F:$F,$C2)
I had been mixing up the syntax and ...

**0**

votes

**1**answer

26 views

### Countif incorrectly matches long number

In Excel 2013 or 2010, if you put this value in column B1:
2014022701000400
And then this formula in column C1:
=COUNTIF(B1,"2014022701000409")
The formula will evaluate to 1. But the numbers ...

**0**

votes

**1**answer

68 views

### Why doesn't formula work on COPIED data?

I'm using countif formulas across two and three columns in an Excel 2010 spreadsheet. The formulas work perfectly on data that is ENTERED but not on data that is COPIED into the spreadsheet, even ...

**0**

votes

**1**answer

61 views

### Excel count all rows that contain certain values for certain fields

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...

**0**

votes

**1**answer

206 views

### using functions in COUNTIF criteria

Do you of any documentation of Excel regarding specifying complex criteria for COUNTIF - e.g. conditions using functions, referring to neighbor cells, etc.
E.g. something like (this one doesn't work)
...

**0**

votes

**3**answers

6k views

### CountIf Formula that counts cells containing any and all dates without having a date range?

I need to simplify a CountIF formula.
Instead of having a date range I just need my COUNTIF to count cells cointaining dates disregarding date range period.
I have tried for example simplifying it ...

**0**

votes

**1**answer

17 views

### Excel 2010 Formula: Finding a dynamic column based on string value, then count # of “0's” within that column

I have tried looking at many different potential avenues at solving this; INDEX, MATCH, DCOUNT, HLOOKUP with INDEX & MATCH, COUNTIF with INDEX & MATCH. What I'm looking for is a way to set the ...

**0**

votes

**0**answers

17 views

### LibreOffice calc countifs with date

I got 3 columns. 1 column(D) text, 1 column(T) 0 or 1, 1 column date(A) 01.01.2010 till 31.12.2014 .
I want to count up until a specific date, for example 10.10.2011:
...

**0**

votes

**0**answers

24 views

### Excel countif criteria to consider collored fields?

Is there a way for Excel's countif function to consider color of a cell in the criteria?
Like if I have 10 cells, and 2 of them are yellow colored, the countif should only count the yellow ones.
Or ...

**0**

votes

**2**answers

143 views

### In Excel, checking if a cell matches one item from a named constant string list

This question is an expansion on In Excel, how do I check if a cell is in a list of values (a range of cells) .
I'm trying to do =COUNTIF(name,G6) and when name refers to some cells, it works fine, ...

**0**

votes

**1**answer

23 views

### Count the number of times a value/string is in a column when other columns are filtered

I am trying to count the number of times a value/string is in a column when other columns are filtered.
Example: I want to be able to filter any column, A through V, and then count how many times a ...

**0**

votes

**1**answer

121 views

### Count instances of a letter in a row if a certain cell in that row contains a specified date

I have a spreadsheet containing a column of dates (week commencing) with columns of data to the right of it, and a conditional formatting rule that highlights this week's row based on the date.
I ...

**-1**

votes

**1**answer

87 views

### How to find that are there any duplicates AND already checked?

I would like to know if there is a duplicate value in my sheet and if it as been already checked.
Example:
Error ID
001
1 002
1 001
003
002
In ...