This is what I tried:
=IF($B:$B=1,(COUNTIF(C2:C33,TRUE)),(0))
Column B has the numbers 1-4. I have to do the same thing for each number, and get a count of how many times column C is true with the number. The formula I wrote there works for when column B is 1, but I can't get it to work for when the value is 2. I would also ideally like to not have to include a specific set of numbers, other than maybe just the total number of rows (110).
Thanks for the help if you can offer it.
=IF($B:$B=1,(COUNTIF(C2:C33,TRUE)),(0))
Column B has the numbers 1-4. I have to do the same thing for each number, and get a count of how many times column C is true with the number. The formula I wrote there works for when column B is 1, but I can't get it to work for when the value is 2. I would also ideally like to not have to include a specific set of numbers, other than maybe just the total number of rows (110).
Thanks for the help if you can offer it.