Tallying Rows based on two different values in two different columns

[Wabahoye]

THe answer to this is probably already posted somewhere, but I'm not finding it. I suspect it is quite simple...

I want to tally the number of times two different values occur within a row. I'm doing fine with one value in one column by using:
=COUNTIF('Master List'!$C$2:$C$20000,"ACT Score Report")

Here is my attempt at getting a count of all rows that have a certain value in one column and another certain value in a second column
=AND(COUNTIF('Master List'!$C$2:$C$20000, "ACT Score Report"),COUNTIF('Master List'!$E$2:$E$20000,"Cold"))

With this I just get a "TRUE"

Thanks in advance!!!

[K m]

AND will only return a TRUE or FALSE. You need an IF or COUNTIF before

[Wabahoye]

OK, that helped a bit, but now, with the following, it seems to be tallying everyone if they have one of the values OR the other value. Here is what reterned a value much higher than I should get:

=COUNTIF('Master List'!$C$2:$C$20000, "ACT Score Report")
+COUNTIF('Master List'!$E$2:$E$20000,"Cold")

In other words, by adding the +COUNTIF I should be getting a subset of the =COUNTIF statement above.

We're so close...thanks for your help!!!