1,898 questions
1
vote
1
answer
114
views
Excel COUNTIF every 2nd column within a year
I want to count certain days within a year by value, meaning all the aaa and bbb as shown below, but I cannot figure out how to incorporate that in the formula =COUNTIFS(A1:D20;">="&...
- 85
0
votes
5
answers
101
views
Custom vba formula within a countif statement
I have a custom formula which returns a colour code based on the background colour of a cell.
Function GetFillColor(Rng As Range) As Long
GetFillColor = Rng.Interior.ColorIndex
End Function
...
- 109
1
vote
1
answer
59
views
Excel Functions For Conditional Count Across Multiple Columns and Exclude Duplicates
I'm doing something wrong here... I keep getting "0" as an answer for the below table, when the answer should be "2".
Goal: To Count the number of Areas (Col A) that have an &...
- 91
-4
votes
2
answers
88
views
Using COUNTIF to check for duplicates?
I am using Nextcloud Forms to have students write comments. They use the same form every week, and it all gets put into one big spreadsheet. (There are 101 students.) Because of the simple nature of ...
- 7
0
votes
3
answers
147
views
How can you count rows meeting one or more of multiple criteria in google sheets?
I need to total multiple criterion amongst separate columns in a spreadsheet.
I attempted the following syntax...
COUNTIFS(criteria_range1, criterion1, criteria_range2, criterion2, ...)
as such...
...
0
votes
1
answer
149
views
Need to identify rows where 3 columns have duplicates
I have a large data file. In this table, there are 3 columns with repeating information, but I need to identify the where the data has duplicates (x 3).
I haven't been able to try anything, as I am ...
3
votes
3
answers
135
views
How do I count the number of columns that have at least a cell where the number is greater than 0?
Year
a
b
c
2017
0
1
3
2018
0
3
0
2019
0
0
0
Given the table above, what's an excel formula to help me count how many columns have at least one cell that's greater than 1? Would prefer to have a ...
- 41
5
votes
4
answers
348
views
COUNTIFS from UNIQUE VSTACK
I have a table that I want to count how many occurrences of values in 2 columns there are, based on the value of a third, and for ease of readability, I want to be able to see those unique values with ...
- 2,581
2
votes
4
answers
147
views
Is there a simple formula to count how many times a combination of two columns appears in excel?
I am trying to quickly count a competition in which teams play each other 2 times maximum.
Round
Date
Field
Time
Home
Away
R1
14/04/2025
F1
19:00
Apples
Oranges
R1
14/04/2025
F2
19:00
Pears
Grapes
R1
...
- 35
-1
votes
3
answers
115
views
COUNTIF using DATE only and name match criteria
I have been tasked to count how many leads does a sales agents takes everyday. So I created a spreadsheet, where the data is being auto populated from a CRM platform, and a separate tab for the ...
- 15
0
votes
1
answer
54
views
How do I replicate COUNTIF in PowerQuery, to count the number of date stamps in column 2 against each reference in column 1
I have the following dataset
Column 1 is a non-unique list of reference IDs
Column 2 contains a date stamp every time an interview is completed
Column 3 contains a date stamp every time an offer is ...
- 23
-2
votes
2
answers
91
views
Excel TextSplit a range and COUNTIF - with wildcards [closed]
My question builds on this previous post: Excel TextSplit a range and countif
I have a very similar use case, except that the values I'm trying to match may have numbers at the end, like A1, A2, CR3, ...
0
votes
1
answer
93
views
How do I COUNTIF visible cells only with multiple criterias?
I have a working formula where column W is the range, and the criteria is LESS THAN OR EQUAL TO -0.15.
=SUMPRODUCT((W:W<=-0.15)*(SUBTOTAL(103,OFFSET(INDEX(W:W,1),ROW(W:W)-MIN(ROW(W:W)),0))))
...
0
votes
2
answers
251
views
How to count each cells in a range that match the content of a different cell
I am trying to use COUNTIF in Excel to find how many items in a range match the contents of a separate cell. I'm using a spreadsheet as a way to score correct answers to an Oscar Predication Quiz (a ...
- 1
0
votes
0
answers
30
views
Trying to calculate "CountIfs" using multiple criteria and named ranges
I have a Table in Excel that has columns for : Country, Status, Cohort. I have given these columns named range values.
The country column would be a 3 letter acronym (BEL, USA, ESP), the Status ...
0
votes
1
answer
44
views
Countif Confusion and troubleshooting
Each column identifies where a particular student falls in their lexile readings. I am trying to place a percentage by adding up the columns and comparing it against the remainder of the columns. For ...
1
vote
1
answer
91
views
Count in specific ways in Google sheets
I am working on getting some specific counts but cannot figure out how to do it.
I have the following sheet:
Duration for subject 1 is 30 min and 90 min for subject 3
Subject 1
Subject 1
Subject 1
...
- 73
-4
votes
1
answer
87
views
Analyzing file names
I have large -- several hundred files -- directory that have the file names in the general format of a unique user name (all A-Z and a-z, underlines, no spaces), followed by 2 or 3 numbers, and then ...
0
votes
1
answer
66
views
Google Sheet formula for concatenation [duplicate]
Names
Value
Jack
A2
Jack
A3
Jack
A4
Tom
A5
Tom
A6
How can I join all values in "Value" column in one cell that map to each name in Column Names? Also, have another column that counts the ...
- 11
0
votes
1
answer
40
views
Looking for equal maximums in a range
I have a list of scores and need to find the maximum value; i.e. the winner(s) but also identify any duplicates of that max value. In other words, a top score wins and on occasions there may be equal ...
0
votes
2
answers
62
views
How to attach multiple attributes to a single data entry and then count all instances of each attribute on google sheets?
I am trying to assign multiple tokens to individual data entries using a single cell per entry for tokens. I am currently using countif as noted here:
=COUNTIF(A:Z, "tokenname 1")
=COUNTIF(A:...
0
votes
1
answer
41
views
How to use >= and column value in COUNTIFS function
I currently have the following function:
=COUNTIFS(MySheet!A:A;**">=3"**,MySheet!C:C;B3)
To make it dynamic, I want to get the value of 3 in ">=3" to be taken from another ...
3
votes
2
answers
135
views
Excel: Counting cells which contain one (or more) specific strings
I'm using Excel 2016, and I have a dataset with a large number of strings, and I need to find out how many cells in a given range ('Geotech Data'!G:G in this case) there are that contain one of 29 ...
- 33
-5
votes
2
answers
283
views
COUNTIFS WITHIN DATE RANGE GOOGLE SHEET
I need to get the count of my NOTICE SENT weekly. I have updated as of date to identify the week I need in the report.
FORMULA:
=COUNTIFS($B$3:$B$8,$F$2,$C$3:$C$8,$F3,$D$3:$D$8,">="&$...
1
vote
1
answer
112
views
Counting Excel timestamps if between to times, but time value different between timestamps and interval ranges
I have a list of timestamped events, and I'm using this formula to count the number of records present in each 15-minute interval:
=COUNTIFS('1 Raw'!$B:$B,">="&$B8,'1 Raw'!$B:$B,"...
- 11
0
votes
2
answers
234
views
How do I compare the names on two sheets and count upon many parameters?
I have a referral tracking spreadsheet that constantly is getting new names added to it. We have a 3rd party that we reach out to for assistance when needed. I want to track the amount of times we ...
1
vote
1
answer
103
views
MS Excel: count if difference between two numbers is in a range, and a third number is within another range
Please could you help me with a tricky (in my book) Excel problem. I have a database of numbers, where I need to count how many cases there are where a subtraction of numbers falls within a range, and ...
0
votes
2
answers
106
views
countIf only in Visible cells of a table in excel
I have a table
I want to return the number of all the cells in a column which is equal to "Defined"
I don't know to how to refer to the last line of my column in the following formula
=...
- 927
3
votes
1
answer
87
views
Assign a number to the univocal rows that conform to a certain filter in array
I have the following table with the following columns:
Column 1: Account Nr.
Column 2: Partner
In Column 3 I added my desired result: Univocal Partner for each Account Nr., numbered
Account Nr.
...
- 41
1
vote
1
answer
1k
views
"Array arguments to COUNTIFS are of different size" - counting the number of rows in Sheets with multiple criteria
I am new to Sheets so this might be a straightforward problem. I have a sheet with editions in various states and types. I am trying to count how many editions were created before a particular date ...
- 21
1
vote
2
answers
71
views
How to Loop Table Range and Enter Function With Multiple Variables?
I have a table that is populated using a CountIfs formula. I would like to code this process into VBA without having to write each cell's formula. I can use WorksheetFunction.CountIfs to automate ...
- 11
0
votes
3
answers
143
views
Highlighting non-first instance duplicates of words and counting highlighted cells
I am trying to check word lists across different rows to check how many words students know from previous lessons. I have a table like the one shown here: https://docs.google.com/spreadsheets/d/...
0
votes
2
answers
119
views
Is there a way to COUNTIF the number of partial name matches (REGEXMATCH) within a column of cells?
Im trying to make an Absent & Late counter based off answers from a google form. The google form collects whos absent and late through checkboxes and in the linked sheets all the names are ...
0
votes
3
answers
122
views
How to count a specific word from a string in a cell from the entire column in google sheets
I have a data in a column like the name of Fruits with comma separate, to which I want to find a count of each fruit occurrence in the cells.
Sample data the entire data is in one column.
Fruits
Apple
...
- 3
0
votes
2
answers
186
views
Countifs with year and other reference cells with text
Looking for a formula for 3 criteria in google sheets to count if all are TRUE:
Number of entries that equal a specific region
Number of entries that say "Yes"
Number of entries that have a ...
1
vote
1
answer
35
views
CountIF with distinct values
I am trying to make a countif -- time between 5am and 2pm-- then return "afternoon", for that part i got it right but I just realized that I was counting every row and some of them are ...
- 21
1
vote
2
answers
107
views
Add a ":" if the field doesn't have a colon
I would like if a user enters a time in a text field in the VBA application, with the colon or without, the text ends up with a colon.
Some examples are 1000, 10:00, 0856, 08:56, 2100, and 23:56.
If ...
0
votes
1
answer
85
views
COUNTIF across a column based on inequality
Id like to count the number of times that Column A is greater than or equal to Column B.
EG:
A
B
1
3
2
4
3
1
4
1
5
8
Which in this case would be two.
I've tried to use
=COUNTIF($A$2:$B$6, A2:A6 > ...
- 11
-1
votes
2
answers
441
views
How to refer to a different sheet based on the value of a cell?
I have an excel file with multiple sheets (Day1, Day2, Day3, etc. with no spaces).
On the master sheet I need to be able to pull certain data from each sheet when I select a value from a drop down ...
- 11
0
votes
2
answers
63
views
Convert COUNIF formula used for Data Validation (Custom formula is) to AppScript to be used as Custom Formula
I have a formula as
=COUNTIF(col_Customers_Categories_Ids, B4)<=1
Where
col_Customers_Categories_Ids refers to the open ended range Customers Categories'!B4:B
Using Data Validation > Custom ...
-1
votes
1
answer
39
views
How to countifs rows with arrayformula with text input in the cell (Google Sheet)?
I am able to use the countifs formula by copy paste the formula down to the sheets but i wish the formula to work around automatically once there is text enter to the header columns.
I wish the ...
0
votes
0
answers
22
views
COUNTIF() function is not counting cells I want [duplicate]
I am doing a small project for fun on excel and I got stumped on a COUNTIF() function. Honestly shocked this happened just based on how simple this code was.
Essentially I made a small stock data ...
0
votes
1
answer
57
views
Using IF Statement with COUNTIFS and also checking if cell is blank in COUNTIFS
I have a quick formula question I can't seem to figure out. I have two worksheets with the following names. One is 'BY Load', the other is 'Inventory Check'. I have a list of numbers (loadnum) on the '...
- 101
-1
votes
1
answer
533
views
how do i count the number of colored cells in a row each time the color changes?
I have a grid in Excel that is 150 rows by 210 columns. For each row, I want to know how many continuous columns of the same color. For example, my row has 176 columns of color A, 10 columns of ...
1
vote
3
answers
311
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 ...
- 33
1
vote
1
answer
189
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 ...
- 61
0
votes
3
answers
103
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
1k
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
217
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 ...
- 99
-1
votes
1
answer
52
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