It sounds like you just need to use the COUNTIF function. Maybe
=COUNTIF(B2:B11,B13).

Ken
Norfolk, Va


On May 28, 1:41*pm, Lucas Reece wrote:
Hi,

I have a spreadsheet where I'm trying to count the number of
occurences of a value against another value (hope that makes sense).
Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA

So, for example in B14, I would like to match value B13 against the
list in B2 to B11 and return the number of occurences of that value
against A14.

Can anyone help please?

Many thanks.