Count Unless??
 

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

Count Unless??
 

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


--

Regards,

Peo Sjoblom


"PCM" wrote in message
...
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

Count Unless??
 

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


"PCM" wrote:

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