Forum Discussion
Solved
Counting instances across three columns not just one
Hi, I am trying to figure out how to code for the resulting tables #1 and #2 in the screenshot, based on the data table. Each publication can be characterized by 1 to 3 categories of humour in domain...
You can count your entries with a combination of FILTER() and SUMPRODUCT().
=SUMPRODUCT(--(TOCOL(FILTER(Publication[[Acategory1]:[Acategory3]],Publication[Type]=B$16),1)=$A17))COUNTIF() does not seem to work with a filtered list.
Thank you! What is the double hyphen in front to (TOCOL ?
This turns true or false into a 1 or a 0, from which the sum can be calculated.