Count Unless??

[Guest]

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

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A100="FAM"),--(B2:B100<>"Cancelled"))

 

[Guest]

=sumproduct(--($A2:$A100="FAM"),--($B2:$B100<>"Cancelled"))