**0**

votes

**1**answer

29 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

**1**answer

32 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:
...

**1**

vote

**1**answer

29 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 ...

**0**

votes

**1**answer

27 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

**1**answer

30 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

**1**answer

61 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

**1**answer

19 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)
...

**0**

votes

**1**answer

28 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

**1**answer

45 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

**1**answer

127 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

**1**answer

41 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

**1**answer

40 views

### How can I return a count of a specific criteria in a range of duplicated items?

I have two sheets (tabs) in an excel document, Sheet 1 and 2. As can be seen below Sheet 1 has 3 columns [1 row], and Sheet 2 has 2 columns [5 rows].
I am looking for a formula that will return the ...

**0**

votes

**0**answers

74 views

### making a running total for excel using countif function, 1 out of 14 drop down options don't work

So im using a table in excel, with several different headings in several collumns, (not pivot just standard) colomn A's name is "status", under these headings are several (about 900) different cases ...

**0**

votes

**0**answers

202 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 ...

**-1**

votes

**1**answer

56 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 ...

**0**

votes

**2**answers

143 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?

**1**

vote

**1**answer

79 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, ...

**0**

votes

**1**answer

197 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
--
...

**1**

vote

**1**answer

209 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**

votes

**2**answers

43 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

**4**answers

1k 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

**1**answer

2k 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 ...

**0**

votes

**1**answer

29 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

**1**answer

347 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

**1**answer

88 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

**1**answer

330 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

**1**answer

260 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

496 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

117 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

**1**answer

112 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

**1**answer

211 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

**2**answers

12k 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

**5**answers

2k 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

429 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

41 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

**2**answers

223 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

464 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 ...

**1**

vote

**2**answers

619 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 ...

**0**

votes

**1**answer

298 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 ...

**3**

votes

**2**answers

333 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. ...

**0**

votes

**1**answer

915 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)
...

**4**

votes

**1**answer

2k 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
...

**-1**

votes

**1**answer

92 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 ...

**2**

votes

**3**answers

9k 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 ...

**0**

votes

**3**answers

12k 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 ...

**1**

vote

**0**answers

37 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 ...

**2**

votes

**1**answer

1k 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 ...

**2**

votes

**2**answers

9k 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 ...

**0**

votes

**1**answer

1k 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 ...

**2**

votes

**1**answer

1k 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 ...