Thread: Count IF Multiple Criteria Match across Multiple Columns

Hello, I am having difficulty being able to Count Occurences where multiple criteria are met across multiple columns.

For example, in column C, I have "True" and "False" Values, and in column H I have "True" and "False" Values. I would like to be able to count the number of occurences where "True" is found in the same row, in both columns.

THe formula I had been using in the past does not seem to be working:

=COUNT((IF('Raw Data'!C$4:C$504="TRUE",IF('Raw Data'!H$4:H$504="True","",'Raw Data'!H$4:H$504))))

Thanks!

Jacob