Counting values based on another cell

[Anthony Slater]

Hi

Column a1:a5 contains "BG"
Column a6:a10 contains "GT"
column a11:a15 contains "OTG"

Column b1:b15 contains random numbers between 1 and 10

How can I count how many 1's, 2's, 3's etc appear in
column b relating to "BG", then "GT" etc...?

(ie BG contains two number 1's, one number 4 and two
number 9's) and so on...)

By the way, BG,GT and OTG can be in more rows other than
a1:a5, a6:a10 etc...ie "BG" can be in more rows than a1:a5

Thanks in advance

 

[Ron de Bruin]

Try this

=SUMPRODUCT((A1:A9="BG")*(B1:B9=1))