Count number of occurences in a list

[Lucas Reece]

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).
See http://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.

 

[T. Valko]

It's not clear what you want to do and your link asks for login credentials.

 

[krcowen]

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

Ken
Norfolk, Va

 

[Lucas Reece]

Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??

 

[Lucas Reece]

Not having a very good night here am I. That meant to say "I'm sure I
have set it for everyone to view and edit without having to login"

 

[T. Valko]

Still asks for login credentials.

 

[Lucas Reece]

Sorry to sound impatient but can anyone help with this please?

 

[Lucas Reece]

Strange.

How about this?

http://spreadsheets.google.com/pub?key=rNc1nfbmtQEoEYzh-R8_s1A&output=html

 

[Lucas Reece]

or this...

http://picasaweb.google.co.uk/lucasreece/UntitledAlbum#5340964977934636546

 

[T. Valko]

OK, that one worked...

Enter this formula in B14 and copy across to D14 then down to B1616:

=SUMPRODUCT(--($A$2:$A$11=$A14),--($B$2:$B$11=B$13))

 

[cabinfrtea]

Does anyone know the formula that will allow an "X" be placed in one column
and will enter a number in another column.

 

[Lucas Reece]

Spot on! Thank you so much for your patience and for the solution.

 

[T. Valko]

You're welcome. Thanks for the feedback!