Forum Discussion
Counting within 3 columns
Hi, not feeling too smart here. How do I code Excel to make the result table below, counting number of unique occurrences of fruit types across 3 columns? Col1 etc refer to Table columns in DataTable...
It may already have been suggested but COUNTIFS works perfectly well with 2D Ranges.
fruit = UNIQUE(TOCOL(Tabelle1,1)) count = COUNTIFS(Tabelle1, fruit)
Officeuser7777 Not a very fancy solution but it could similar to the one in the attached file.
Sorry I just see "#NAME?" in the result cells
Which Excel version are you using?
- Mac Office365
Officeuser7777 Perhaps Power Query is something you would want to consider. Especially when your real data is more complicated than just Apples and Bananas 🙂
- Thanks, I looked into it, but in another thread I got two very useful suggestions for counting across 3 columns that worked great using SUMPRODUCT. That was even more complicated than this task, so I'm hoping someone can suggest the syntax for a formula like that.
