Count number of occurences in a list
 

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?k...G1DfgoUtdbx1PA

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.

Count number of occurences in a list
 

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

--
Biff
Microsoft Excel MVP


"Lucas Reece" wrote in message
...
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?k...G1DfgoUtdbx1PA

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.

Count number of occurences in a list
 

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.

Count number of occurences in a list
 

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


On 28 May, 18:53, "T. Valko" wrote:
It's not clear what you want to do and your link asks for login credentials.

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Count number of occurences in a list
 

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"

On 28 May, 19:07, Lucas Reece wrote:
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??

On 28 May, 18:53, "T. Valko" wrote:



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

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Count number of occurences in a list
 

Still asks for login credentials.

--
Biff
Microsoft Excel MVP


"Lucas Reece" wrote in message
...
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"

On 28 May, 19:07, Lucas Reece wrote:
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??

On 28 May, 18:53, "T. Valko" wrote:



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

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Count number of occurences in a list
 

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

On 28 May, 18:41, 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.

Count number of occurences in a list
 

Strange.

How about this?

http://spreadsheets.google.com/pub?k...1A&output=html


On 28 May, 19:24, "T. Valko" wrote:
Still asks for login credentials.

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...



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"

On 28 May, 19:07, Lucas Reece wrote:
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??

On 28 May, 18:53, "T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Count number of occurences in a list
 

or this...

http://picasaweb.google.co.uk/lucasr...64977934636546



On 28 May, 20:48, Lucas Reece wrote:
Strange.

How about this?

http://spreadsheets.google.com/pub?k...-R8_s1A&output...

On 28 May, 19:24, "T. Valko" wrote:



Still asks for login credentials.

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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"

On 28 May, 19:07, Lucas Reece wrote:
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??

On 28 May, 18:53, "T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Count number of occurences in a list
 

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))

--
Biff
Microsoft Excel MVP


"Lucas Reece" wrote in message
...
Strange.

How about this?

http://spreadsheets.google.com/pub?k...1A&output=html


On 28 May, 19:24, "T. Valko" wrote:
Still asks for login credentials.

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...



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"

On 28 May, 19:07, Lucas Reece wrote:
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??

On 28 May, 18:53, "T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Count number of occurences in a list
 

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

Count number of occurences in a list
 

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


On 28 May, 21:09, "T. Valko" wrote:
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))

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...



Strange.

How about this?

http://spreadsheets.google.com/pub?k...-R8_s1A&output...

On 28 May, 19:24, "T. Valko" wrote:
Still asks for login credentials.

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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"

On 28 May, 19:07, Lucas Reece wrote:
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??

On 28 May, 18:53, "T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Count number of occurences in a list
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Lucas Reece" wrote in message
...
Spot on! Thank you so much for your patience and for the solution.


On 28 May, 21:09, "T. Valko" wrote:
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))

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...



Strange.

How about this?

http://spreadsheets.google.com/pub?k...-R8_s1A&output...

On 28 May, 19:24, "T. Valko" wrote:
Still asks for login credentials.

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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"

On 28 May, 19:07, Lucas Reece wrote:
Sorry. Can you try the link again please. I'm sure I have set it
for
everyone to view and edit with login?!??

On 28 May, 18:53, "T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Lucas Reece" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -