Count/Match formula I am having trouble coming up with a formula to do a quick c
ID: 3564175 • Letter: C
Question
Count/Match formula
I am having trouble coming up with a formula to do a quick count for me on items that match a certain criteria. I might be overthinking this but I feel like I need a match condition then a count formula. So I am looking to get a count of the "x" for each specification for each type of animal down toward the bottom where the question marks are. (Don't judge me on the classifications as I was just trying to think of a quick example for what I was trying to do) :-) Any guidance would be appreciated or suggestions for a formula to try if I am not thinking of the best way to get my result. Thank you!!!
Count/Match formula I am having trouble coming up with a formula to do a quick count for me on items that match a certain criteria. I might be overthinking this but I feel like I need a match condition then a count formula. So I am looking to get a count of the ''x'' for each specification for each type of animal down toward the bottom where the question marks are. (Don't judge me on the classifications as I was just trying to think of a quick example for what I was trying to do) :-) Any guidance would be appreciated or suggestions for a formula to try if I am not thinking of the best way to get my result. Thank you!!!Explanation / Answer
Put this in C16 and drag right and down for other cells
=COUNTIFS($B$4:$B$10,$B16,C$4:C$10,"x")