The following is giving me a total that is more like the first value OR the second value. I need it to tally only those rows that have BOTH values. In other words, by adding the +COUNTIF I should be getting a subset of the =COUNTIF statement above it.
=COUNTIF('Master List'!$C$2:$C$20000, "ACT Score Report")
+COUNTIF('Master List'!$E$2:$E$20000,"Cold")
Probably something real simple...thanks!!
Bookmarks