Hi!
I need to count how many times a criteria shows up in 36 different columns,
I would like to do it without summing 36 Countifs functions,
Is that possible?
Ex:
|Name |***|car color| hat color | Shirt color | undies color |
| John | M | Red | Red | Red | White |
| Marcus | M | Blue | White | Yellow | Pink |
| Maria | F | Pink | Red | White | Blue |
| David | M | Blue | Red | Gray | Red |
Q: How many Red Itens Do the Males have?
A: 5
Thanks!
Bookmarks