Count occurrences in a table (CountIf) across rows & columns

Hi there! Newbie to AppSheet and struggling with a basic CountIf. I have a table with multiple rows & columns that have the same drop-down options. I’d like to tally the occurrence of each selected across the table. So let’s say I have Table 1 with multiple columns that have a drop-down with the options Red, Blue, Green, I’d like a formula in Table 2 to count the number of cells where “Red” is selected in all of Table 1. I’m sure it’s simple, but struggling to find how in support docs.

Thanks!

Presley

0 7 2,554
7 REPLIES 7
Top Labels in this Space