I am using Excel 2000 and need to count the incidents of a defined value in a
column unless another defined value occurs in a different column in the same
row. For example, count the value "FAM" in column $A2:$A100 unless the value
"Cancelled" appears in the same row in column $B2:$B100.

Thanks