Hi guys,

Anyone can help me what is the formula in excel MS office 2007
Of counting the unique numbers in one column A against column B
Example:

Column A (Cheque Numbers) Column B

1234 Charice
1235 Charice
1235 Charice
1233 Isabel
1236 Isabel
1236 Isabel

How many cheques received by Isabel and Charice
Please help.
Thanks

Like this:

=SUMPRODUCT(--($B$1:$B$10="Charice"),--($A$1:$A$10<>"")/COUNTIF($A$1:$A$10,$A$1:$A$10&""))