All Questions
Tagged with google-query-language count
26 questions
1
vote
2
answers
61
views
List non-unique entries and their counts sorted in descending order
If I have a list of names in a sheet for example:
First Name|Last Name|Something else|
Maria|Miller|...|
John|Doe|...|
Maria|Smith|...|
Marc|Meier|...|
Marc|Park|...|
Maria|Muster|...|
Selene|Mills|......
- 397
1
vote
1
answer
1k
views
How to Importrange + CountIf on Google Sheets
I need to import information from another google sheet, COUNTIF that information under the criteria of one column saying "VIL" and another column saying "Pass"
I am using ...
- 13
-1
votes
1
answer
66
views
Google Sheets: Chart counting combinations
In the following Google spreadsheet
Description
No. of participants
Severity
Problem 1
2
Minor
Problem 2
2
Major
Problem 3
1
Minor
Problem 4
1
Minor
Problem 5
2
Major
I would like to create a chart ...
- 307
2
votes
2
answers
931
views
Query Select Row and Column together one statement
I work on a google sheet, where I should see the number of holidays per day for each team.
The table looks like this:
[table]
A
B
C
D
E
1
Employee Name
Team Name
01/03/2022
02/03/2022
03/03/2022
2
...
- 23
0
votes
1
answer
360
views
Count Names In Multiple Rows & Group Them By Location In Google Sheets
I've been attempting to use Query to group up and count information in the Attempts column below, but I'm running into walls.
When using a Query formula like below, I seem to be on the right track in ...
- 37
1
vote
2
answers
151
views
Google Sheets Vlookup with dynamic result i.e. keep blank rows and show result in next matching value
Column A in the below image is user input and result is expected in column B and C. Result is to be derived from the data available in Column F and G by matching column A with Column E.
Any help on ...
- 175
1
vote
1
answer
283
views
I need a Google Sheets formula that will count the dates and display total per month
I need a formula that will count the dates in column A and show how many of each month.
Example of the data in Column A
12/1/21
12/10/21
12/29/21
12/30/21
1/11/22
1/12/22
5/2/22
The returned data ...
- 73
1
vote
1
answer
181
views
If column A is equal to current month then do. I am needing my formula updated please
I have a formula to count number of times the word "test" is on a certain sheet
=COUNTIF(FILTER('Archived D'!E:E,ISNUMBER(MATCH('Archived D'!H:H,Match!$A$2:$A$12,0))),A2) + COUNTIF('IAD'!E:E,...
- 57
1
vote
1
answer
92
views
ARRAYFORMULA with COUNT
im trying to come up with an ARRAYFORMULA to substitute formulas on every row
=IF(ISBLANK(A2);""; COUNTA(FILTER((Derivatives!B:B);INDEX((Derivatives!D:D);0;0)= left(A2;4);INDEX((Derivatives!...
- 181
1
vote
1
answer
414
views
Query importrange to count to number of times a value is in a column
In this google sheet I have text data in range O3:O:
https://docs.google.com/spreadsheets/d/1xNFVHLnQGkRgZdLmejCyU0BByOPBY8NMoIYj6SkTFGY/edit?usp=sharing
My objective:
Query + importrange to count the ...
- 325
2
votes
1
answer
54
views
Average use based on number of times an email address appears within a period
I have a small data set that I need to find the average number of times each individual user (email column B) appears within a defined period.
In the sheet link I have the total number of times each ...
- 325
0
votes
1
answer
84
views
Excel Formula for counting words with same starting letters
Suppose I have a column of words, in some cases more than 1 word in each cell, separated by a comma or space. I want to calculate the number of words starting with A, B, C...,Z separately.
- 11
1
vote
3
answers
729
views
How to combine data from multiple rows into a single row based on numbers and certain texts in Google Sheets?
I am creating a journal for trading purposes. In trading, Let's say I bought +1 Share of Disney at $1 and Sold -1 Share of Disney at $2. Now this trade will be shown in two different rows, one row ...
0
votes
2
answers
43
views
Determine the number of terms by year in Google Sheets
I have two tabs in my Google Sheets file.
One of these tabs contains our guests' data.
The other is a summary of payment methods by years.
Could you explain me, how can I fill in the summary cells ...
- 3
1
vote
1
answer
841
views
How to return nth value from one Column based on another Column using ArrayFormula or QUERY?
I'm working with a long, growing list of ratings data, and I'm trying to find a way to reference the 2nd (3rd, 4th, etc.) rating.
Here's a link to the sheet I'm working on.
The data I want to ...
- 85