Count number of occurences in a list

  • Thread starter Thread starter Lucas Reece
  • Start date Start date
L

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.
 
It's not clear what you want to do and your link asks for login credentials.
 
It sounds like you just need to use the COUNTIF function. Maybe
=COUNTIF(B2:B11,B13).

Ken
Norfolk, Va
 
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??
 
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"
 
OK, that one worked...

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

=SUMPRODUCT(--($A$2:$A$11=$A14),--($B$2:$B$11=B$13))
 
Does anyone know the formula that will allow an "X" be placed in one column
and will enter a number in another column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet Formula Returning Sum of a Series 16
Counting by color 3
Stripe out duplicate data 5
Counting the number of times a character occurs in a cell 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Lookup returning wrong results 0
Trouble trying to do a 'Count IF' 2
Count Max values in a range 6

Back
Top