COUNTIF generally refers to a worksheet function within a spreadsheet program that counts cells in a range based on a specified condition. This tag can also be used for COUNTIFS, which provides a similar function but allows multiple ranges and criteria.

learn more… | top users | synonyms

0
votes
6answers
3k 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
1answer
26 views

Count the amount of times a value appears combined with a certain event

I basically have the following list: How can I count the amount of times John won? I have tried using both countif and countifs but have find no positive result. I either get "#VALUE!" or a simple ...
0
votes
1answer
30 views

index and match 2 criteria with COUNTIF

I know many questions have been asked for using INDEX and MATCH with criteria and returning a unique list without duplicates. And I have that much working. But I ran into a problem. Here is my data: ...
0
votes
2answers
24k 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
2answers
5k views

Excel formula to count when value changes?

I have an Excel conundrum I can't seem to crack. In Column A I have a long list of counties, and each of those counties is a member of a larger group of counties that pertain to a particular funding ...
-1
votes
4answers
43 views

Countifs function: two criteria in the same range for text

I am using the countif function to count only those items achieving a certain criteria. My problem is I have a certain range wherein there are two items (criteria) I want to include in my logic so ...
1
vote
1answer
31 views

Excel: Count the number of matches between lists

I have two lists, each on separate tabs. One list occupies B5:B10 (though the number of rows could change) and the other is named "proteins". I want to count the number of matches between the lists (...
0
votes
1answer
39 views

How to countif date in a specific column [closed]

how to countifs date in a specific column and to differentiate between start date and end date count.
0
votes
2answers
28 views

Nested countif's frying my brain

What I want is the following scenario: If all values are "Pass" then display "Passed" If all values are "Fail" then display "Failed" If all values are "Incomplete" then display "Not Started" If all ...
1
vote
2answers
53 views

How to use OR in a COUNTIF function when dealing with dates and “>” characters

I want to write a function whereby I could count a cell if it is blank OR greater than a date. This is a piece in what will be a much larger formula so looking to avoid a solution of SUM(countif(D:D,...
0
votes
1answer
52 views

How does this SUMPRODUCT(COUNTIF( )) function work?

I was searching for a solution to count distinct values in a range, and came across this article. The example provides a list of ten names comprised of four unique entries. It then uses the ...
0
votes
2answers
57 views

Excel counting “A”'s with cell values of “A,B” “R,A” etc

Trying to count the number of individual variable in Excel but Countif doesn't seem to fit my needs For example individual cells have "A","A,B", "A,J", etc and I want to count the number of "A"s - is ...
1
vote
1answer
30 views

Excel: conditional COUNTIF?

How can I evolve an =COUNTIF(A:A;"foobar") so that if the cell in column A is empty it looks (for the "foobar") in column B?
0
votes
0answers
635 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: =COUNTIFS($D$1:$D$1000;"Law";...
1
vote
0answers
41 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 ...
1
vote
1answer
265 views

Excel Sort and Lookup Values Formula

I am trying to create some sort formulas on excel. An example is shown below regarding players and their corresponding scores. I need to query the "Raw Data" and get the "Top 3" players and their ...
1
vote
1answer
83 views

Count cells containing all 3 separate words in Excel

I have this excel file containing multiple rows. I wanted to convert the following expression to an excel formula but can't find a reference on how to: COUNTIF(CELL CONTAINS "APPLE" AND CELL CONTAINS ...
0
votes
2answers
157 views

Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added

I have a big data set. What I want to happen is for each customer number occurrence, when the transaction type column has an entry CC or SO, it needs to be calculated as a donation. So for each ...
5
votes
3answers
115 views

Excel Countif 0, 00, 000 separate entries

I want to count 0, 00 and 000 in my data which is formatted as TEXT but the countif() formula gives me same value for each of the three search criteria. Please find the attached image for more ...
5
votes
2answers
4k 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 ...
1
vote
2answers
154 views

COUNTIF and SUM in Excel with different ranges

Is there a more efficient way of making the following function?: >=COUNTIF(A1,">0")+COUNTIF(C1,">0")+COUNTIF(E1,">0")+COUNTIF(G1,">0") I want to count if the cell is bigger than 0 ...
0
votes
1answer
79 views

Need unique count of text from multiple columns by category

My data looks something like (assume begins in A1): Category,Label1,Label2 Dogs,blank,doe Dogs,zoo,blank Cats,zoo,yup Cats,doe,hgg Cats,blank,doe What the result should look like: Dogs,...
0
votes
1answer
31 views

Count two different text items in a row or column

I have a table (schedule) that I have a COUNT set up to count the number of times a text occurs. My table: A | B | C | D | E | F | G | H John | Rooms | RoomsPM | OFF ...
0
votes
1answer
490 views

How to count cells with values in another sheet's last column?

I want to count cells which are not blank in another sheet's last column. Now I'm using this formula in sheet1: =COUNT($'Sheet2'.H11:H54). At the end of every month I add 2 columns to sheet2. ...
0
votes
1answer
171 views

Count matches between two arrays

How can I count the number of entries two arrays have in common, using just standard excel formulae (i.e. no VBA)? Can't find an answer anywhere. e.g. A B +------------- 1| 1 10 2| ...
0
votes
1answer
126 views

How to compare and sumproduct two cells value and use multiple criteria in IF in Excel 2013

I want to compare the month value (=TEXT(A1,"MMMMMM")) from sheet A with a cell value (JULY) in sheet B using an IF statement. If the months are same then I need a sumproduct of the cells in sheet A. ...
0
votes
1answer
28 views

COUNTIF/COUNT Function help required to count the filtered data for the subsequent columns

I am using a normal COUNTIF Function to know the count of "Box 9" I have placed this in one cell "I12" and i am using the formula. I am filtering the data with the column J. 1) =COUNTIF($X$36:$X$...
0
votes
1answer
65 views

Functions (specifically text functions) within a countif function

Is there any way to nest text operators within a countif? I want to check if the first 4 characters of a file are in the form A**. =Countif(Left(A1,4),"A??.") doesn't work, but I can put in a =...
2
votes
1answer
178 views

Excel: count number of unique matches for multiple criteria

I have sheet1 with a list of people and their allergies/dietary requirements. There are nine allergies/dietary needs, and each person has 1 or more allergies. Each requirement is a column, each person ...
0
votes
1answer
58 views

Excel 2013 - Multiple Countifs

I've been progressing through a series of countifs but have come stuck. I need to count the number of "yes" each week, where there was not "Yes" in the previous weeks, but count the "Yes" if there was ...
0
votes
0answers
391 views

excel - how to count number of names in a column, name is specified in a cell

I have two worksheets, "Clients 2014" and "Receipts 2014". The receipts have client names for each row (each row is a receipt). The search key is in the "Clients 2014" worksheet. I want to ...
3
votes
2answers
682 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. ...
-1
votes
1answer
57 views

counting if certain things match

I have a set of data that looks like this: Period Address Name City Carrier Move ID P1/2014 WAL-MART CANADA INC. MISSISSAUGA CMV0066539 P1/2014 WAL-...
0
votes
2answers
438 views

Excel Countif Function Error [closed]

I need to count values with < and > infront of them but excel won't recognize them as true numbers. How do I use a count function with true values and values?
2
votes
1answer
271 views

How do I count multiple words available in sentences and multiple rows (countif, search)?

here is screenshot for the sheet. https://flic.kr/p/qZb8ot in column A there are some senteces list below: A2. T-shirts, Varsity A3. T-shirts, Sticker, Mug A4. T-shirts A5. T-shirts, Pin, ...
1
vote
1answer
311 views

Advanced data consolidation in Excel

I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...
1
vote
1answer
468 views

Excel: How to count cells, whose date values represent a day between monday and friday?

I want to count cells, whose values are dates, under the following condition: The date value entered must be a day between Monday and Friday. Assume the following data and my try: Column A -- 15.01....
-1
votes
2answers
51 views

Trying to use SEARCH function in Excel

I'm trying to do something on Excel which is a little bit over my head and was wondering if anyone out there can help: I'm trying to search through a table (specifically one column) for several ...
2
votes
4answers
3k views

Using COUNTIF in Excel to count number of “Greater than” values in an array of values

So here is my situation. I'm a principal creating a tracker for my teachers to use to track student growth on assessments. In the current tracker it is set up like this: % of ...
0
votes
1answer
89 views

How can I set up logic to count the number of occurences in a month for a list of dates?

I have dates that look like this: 9/24/13 9/24/13 10/7/13 10/7/13 10/14/13 10/16/13 10/22/13 10/22/13 10/30/13 I need logic in a cell that will count the number of September occurrences. Then I ...
0
votes
1answer
690 views

Excel 2013 Multiple Validation Rules

I have a 2 part problem that I am having issues with... mainly part 2. I have gotten the first part to work by itself. 1) I have a column which contains part numbers (###-#####-###). I am using data ...
0
votes
1answer
162 views

How to count only shown in filter heading using COUNTIF (Excel 2010)

I have a list of names, company, meals etc. and there is a filter in each column. In the top, there is a list of the 5 type of meals, and COUNTIF() is used to count the different types of meal in the ...
2
votes
1answer
559 views

MS Excel: Count frequency of similar values in between blank cells

I'd like the count the frequency of identical values in a row. The value must occupy at least two cells and must be beside each other. I'd like to post the image here but i do not have enough ...
0
votes
1answer
64 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
1answer
382 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
0answers
194 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 ...
1
vote
1answer
181 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 ...
0
votes
1answer
433 views

Countif incorrectly matches long number [duplicate]

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
2answers
591 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
2answers
303 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 ...