I am not sure if this solution should be one or two formulas but I am ok with two.
I have a small spead sheet 17 column, each column has 3 list.
The list are numbers and X. I would like to count the numbers and the X. given 2 different total.
Can someone help please.