TIL — Counting frequency of values appearing in a column or row, in Google Sheets
TL;DR — here’s the best way, the formula to use in Google Sheets — https://gist.github.com/Weiyuan-Lane/4727e6dea9626c51c4f269df822edffd
[ Explanation in article below ]