# Tagged Questions

23 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 ...
26 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 ...
31 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 ...
24 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 ...
221 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 ...
20 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 ...
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 ...
57 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 ...
149 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 ...
114 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 ...
198 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) ...
517 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 ...
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 ...
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 ...
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 ...
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 ...
697 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 ...
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 ...
458 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 ...