All Questions
100
questions
0
votes
1
answer
1k
views
How to count distinct values in one column for each distinct value in another column in MS Excel?
Say I have the following data in an Excel sheet:
Country Fruit
USA Banana
USA Apple
USA Apple
USA Orange
USA Banana
USA Apple
UK Banana
UK Banana
UK Apple
I ...
0
votes
3
answers
137
views
Excel - Indirect Formula
another question regarding Excel Indirect Formula.
I have columns E1:J202 filled with one of the following:
Green
Amber
Red
How can I use the indirect formula to count each of the above separately ...
0
votes
1
answer
144
views
Finding Unique Values across many columns
I'm working on what I thought would be a simple task that has become quite complicated.
In Column A, I have a Field Name. In columns B through ANV (1059 columns) I have values associated with that ...
0
votes
2
answers
211
views
Count number of rows that have X in cell A or B or C
I think looking at the photo is the easiest way to show what I need:
Original Table
How do I set up a single formula to count the number of kids who failed an exam section?
What I've managed so ...
0
votes
1
answer
235
views
Count If Formula for 2 Separate Criteria
I am trying to write a CountIf Excel formula for 2 separate criteria on the same range. The range consists of a formula that generates a 1 or 2, so the Countif formula tells the user what category ...
0
votes
2
answers
162
views
Excel - keep the absolute reference from inserting row using COUNTIFS function
How can I use the absolute reference Column in a different sheet in COUNTIFS function?
COUNTIFS(Scenario!C:C,C21,Scenario!H:H,"PASS")
We are inserting new column on H, and then the reference range ...
1
vote
1
answer
208
views
Sum the Count of Min of each column by row
I am trying to automate a spreadsheet that will keep a running tally of the most negative topics week over week (kind of like Billboard top 100).
I have tried to get Column A(No.1) to calculate the ...
1
vote
2
answers
2k
views
COUNTIFS when criteria has more than 255 characters
I was looking for a formula in Excel that will search into different ranges parts of text that meet another criteria. So, basicalLy it is a COUNTIFS. While trying to use the formula, which perfectly ...
0
votes
2
answers
235
views
Count If: Using Formula to Create Range
I am trying to create the Range of a CountIf formula, using formulas. I found some data on using INDIRECT, but it doesn't seem to fit the bill. Here is the specific problem:
SHEET 1:
A B ...
1
vote
1
answer
100
views
Cross table of joint games
I have a list of games of badminton that have been played over a period of time:
Each row contains the game id and one player id. Each game was played with four players. So, for each game there are ...
1
vote
2
answers
15k
views
Simple pattern with Excel COUNTIF to match a substring?
How do I fix this formula: =COUNTIF(A1:A10,"*jim*") to match anything containing the sub-string of "jim" but from a cell, as: =COUNTIF(A1:A10,C11) where cell C11 contains the text "jim"?
Perhaps ...
0
votes
1
answer
516
views
how to pass a string value into COUNTIF?
For this formula:
=COUNTIF(A1:A10,"jim")
how can I pass in a variable? That is, let's say that cell C11 has the value "jim"; can I then do something like:
=COUNTIF(A1:A10,TEXT_VALUE_OF_CELL(C11)) ...
0
votes
2
answers
594
views
Excel – using multiple criteria in COUNTIFS function
I need to create a formula that counts the number of times there is an overdue date in column I, where the corresponding cell in column J is blank.
I enter a date in column H (date appointed). There ...
0
votes
1
answer
54
views
How to properly use COUNTIFS with a defined named range?
I have a formula that counts the number of contact attempts for each month. The problem I am facing is that the formula only goes up to row 2000. How can I rewrite my formula to adjust with newly ...
-1
votes
1
answer
295
views
Using COUNTIFS function with criteria if a value is in range of values
I need help with COUNTIFS function.
There are values in column B: a,b,c,d,e,f,....
I want to use COUNTIFS function to count items in column A, if the values in column B is included in range {a,c,f}