"Blair" wrote in message
...
Hi, I have two columns with different values in and I would like to count
the
number of times certain values appear in the same row.

i.e. Column A contains random numbers from 1-10
Column B contains random letters between A-Z

How could I count the number of times the number "1" is in the same row as
letter "A"??

Struggling at the moment with this so any help would be appreciated.

The shortest formula:
=SUMPRODUCT((A1:A10=5)*(B1:B10="B"))

Bruno