countunique
Google Sheets: Count of unique items, considering two criterias
I'm looking for a simple way to count unique items based on two criterias. I tried it by myself with various combinations of Arrayformula, Countif, Query, Countuniqueifs and/or Filter, but couldn't make it work.
The example.
I have a list of different IDs (with some gaps in between) in column A and an criteria in column B. The logic I want to have applied is: Sum of all unique IDs, except of 'empty', which have bought=yes.
In the example the following IDs would be legit and have bought=yes: Apple (row 2) Juice (row 5) Kiwi (row 9) Pear (row 12)
So the result should be: 4
Does anyone have a convenient solution?
Solution
I am sure there are many ways to solve this, I used the QUERY() and UNIQUE() functions
=query(UNIQUE(A1:B13); "SELECT COUNT(Col1) WHERE Col2 = 'yes' LABEL COUNT(Col1) ''"; 1)
- How do you find the row count for all your tables in Postgres
- How can I count and show Unicode Characters when insert onclick to textarea?
- PowerShell .Count returns 1 on empty array
- Return the number of objects in a slicer from another workbook
- Snowflake - COUNT (DISTINCT ...) window function with ORDER BY
- (How) can I count the items in an enum?
- Sum rows that match a condition and the others that dont in the same query
- How to count distinct column values in Google Sheets?
- Fast way to discover the row count of a table in PostgreSQL
- How to efficiently count the number of keys/properties of an object in JavaScript
- Using Count to find the number of occurrences
- Adding two-way fixed effects for zero inflated Poisson model
- See whether an item appears more than once in a database column
- Count cells with two conditions
- Excel Distinct Counts on Pivot Tables are aggregating incorrectly
- Handle result when dynamic SQL is in a loop
- How to introduce a random error within a Bayesian count model?
- Postgresql incorrect COUNT() value with left outer join
- Select counts from one table based in the results from another table
- Avoiding overlap in frequency and document frequency count in Quanteda
- Add column count of occurrences
- Get all data COUNT fastest from large table based on condition
- Output a list from a sentence and count characters for each word
- PHP: Count a stdClass object
- Query data and how many rows have that date in mysql
- Count "truthy" values in a 2d array
- Count the number of objects in an array of object with a specified property value
- Count rows of a 2d array which contain a qualifying column value
- Determine if two arrays have at least 3 shared values
- Count the occurrence of one vector's values in another vector