Questions tagged [countif]
COUNTIF is an Excel function which allows for the counting of values in a range where the values meet a criterion.
countif
1,867
questions
1
vote
3
answers
79
views
Excel Column to Count Unique Values
I have a list of names in a column in excel. The names are duplicated many times in the data. I want to create a new column that will put a 1 for each time a name first appears and 0’s after that. My ...
- 11
1
vote
1
answer
31
views
MS Excel - Count rows where multiple columns meet different criteria
I am trying to automatically count samples that pass or fail based on multiple criteria. Countifs works beautifully for the pass condition where all criteria must be passed, but I'm struggling with ...
- 51
0
votes
3
answers
93
views
Count all countries that are not on the list
Every month I have to compile a count of all countries received that month. Specific countries are counted individually for occurences, and the rest goes into a count for "other".
For ...
- 1
1
vote
2
answers
58
views
Excel - COUNTIFS with multiple match criteria including a date condition
I am trying to pull all records that have been resolved in the last 7 days. I want to count these records by area.
Here is my Excel workbook.
Sheet 1
Row 1 for Titles: **Area (column A) | State (...
0
votes
2
answers
62
views
How to get a string array in an Excel cell and use as a reference
I have the following formula:
=SUM(COUNTIF(Country;{"CHN";"SGP";"AUS";"MYS"}))
where Country is a Column.
I would like to have a cell containing the array of ...
- 89
-1
votes
1
answer
33
views
How to increment range for ARRAYFORMULA function in Google Sheets across different rows
I am trying to create a Split calculator on google sheets for me and my friends whenver we go out to eat for something like Korean food.Sample Split Calculator
I have tried to use ARRAYFORMULA with ...
- 1
0
votes
1
answer
44
views
MS Access How to produce a query that returns the same as countifs
enter image description here
I have a table of customers and products.
I would like to use MS ACCESS to produce a table with a single row for each customer and a column that counts each product they ...
-3
votes
2
answers
82
views
Counting number of unique values in one column if data in a 2nd column matches anything in a 3rd column
I have data that will be changing daily.
I'd simply like to get a count of unique values from the first column if the data in the same row of the 2nd column matches anything in the 3rd column located ...
2
votes
1
answer
86
views
Strange behavior of CountIf() on hex values
Environment: Excel 2021 under Windows 11 Pro 64.
We know that Excel's CountIf() has the nasty behavior of converting text that looks like a number to a number before counting. But now, it appears that ...
- 1,659
0
votes
1
answer
61
views
checking the presence of any of the character from a certain set of characters in an Excel cell, and returning values accordingly
I have a data set in which there are several cells that should contain numbers but are formatted as text.
What I am trying to do is enter a formula that checks for the presence of any of the following ...
0
votes
1
answer
21
views
Compare row of three ETFs (text) to previous row of three ETFs (text) for changes. Order not counted. Across large dataset in google sheets
I'm trying to track trades (changes) in a portfolio that uses 3 ETFs which are ranked, and so can alter month-to-month. Basically I need a formula that can compare 3 text cells to 3 previous text ...
- 21
-1
votes
2
answers
85
views
Changing value in one column with sequential information when cell value changes in another column
Cannot find information on web, so asking for help. All solutions I find are on python. I need solution on google sheets.
I have sequential information, which needs to be updated based on values in ...
0
votes
2
answers
69
views
Counting sets of values in a column associated with another columns values [duplicate]
I am asking for a solution to this scenario in Excel.
I want to get a count of sets of unique values in one column that are associated to values in another column.
Example:
A B C
1 a 3
1 a 3
2 ...
- 13
1
vote
1
answer
33
views
Adding more (3rd) criteria to COUNTIFS
i'm creating a log to record replaced ropes at a climbing gym, with various "averages" output for overview.
i'd like to add an option to filter these "averages" by rope type, ...
- 37
3
votes
2
answers
107
views
Excel: Inconsistent results of CountIf() on string with tilde
Is this a bug in Excel, or is there a reason for the different results in the table below? If it's a bug, is there a way to predict what strings will be affected by it?
In both match() and CountIf(), ...
- 1,659