count entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

given the table below - example -

John 2
Fred 3
Eric 1
Eric 3
John 4
Eric 2
Fred 2
Eric 1

1. I want to count how often a name occurs
e.g. Eric = 4

2. I want to calculate the sum of the values for a certain person
e.g. Eric = 7

Any solution?

Thanks!

tom
 
=COUNTIF([range],"Eric") --> replace [range] with the correct range on your
worksheet.

=SUMIF([range],"Eric") --> replace [range] with the correct range on your
worksheet.
 
Hi! Thanks for the answers!

still encountering problems with SUMIF. The actual table contains sevrel
colums with data.

an example:

A B C
1 green red
2 John 4 2
3 Fred 1 3
4 Eric 111 1
5 Eric 5 3
6 John 5 4
7 Eric 5 2
8 Fred 5 2
9 Eric 5 1



=SUMIF(A2:C9,"John")

The result is 0, how to get 2+4=6 as a result?

Thanks a lot!

tom


Dave F said:
=COUNTIF([range],"Eric") --> replace [range] with the correct range on your
worksheet.

=SUMIF([range],"Eric") --> replace [range] with the correct range on your
worksheet.
--
Brevity is the soul of wit.


tom ossieur said:
Hi!

given the table below - example -

John 2
Fred 3
Eric 1
Eric 3
John 4
Eric 2
Fred 2
Eric 1

1. I want to count how often a name occurs
e.g. Eric = 4

2. I want to calculate the sum of the values for a certain person
e.g. Eric = 7

Any solution?

Thanks!

tom
Click to expand...
Click to expand...
 
=SUMPRODUCT((A2:A18="john")*B2:C18)

--
Don Guillett
SalesAid Software
(e-mail address removed)
tom ossieur said:
Hi! Thanks for the answers!

still encountering problems with SUMIF. The actual table contains sevrel
colums with data.

an example:

A B C
1 green red
2 John 4 2
3 Fred 1 3
4 Eric 111 1
5 Eric 5 3
6 John 5 4
7 Eric 5 2
8 Fred 5 2
9 Eric 5 1



=SUMIF(A2:C9,"John")

The result is 0, how to get 2+4=6 as a result?

Thanks a lot!

tom


Dave F said:
=COUNTIF([range],"Eric") --> replace [range] with the correct range on
your
worksheet.

=SUMIF([range],"Eric") --> replace [range] with the correct range on your
worksheet.
--
Brevity is the soul of wit.


tom ossieur said:
Hi!

given the table below - example -

John 2
Fred 3
Eric 1
Eric 3
John 4
Eric 2
Fred 2
Eric 1

1. I want to count how often a name occurs
e.g. Eric = 4

2. I want to calculate the sum of the values for a certain person
e.g. Eric = 7

Any solution?

Thanks!

tom
Click to expand...
Click to expand...
Click to expand...
 
Thanks a lot!

next step makes it more complicated..
given a list of years instead of names.

A B C
green red
1 1974 2 2
2 1985 6 1
3 1983 2 3
4 1974 1 3
5 1983 2 1
6 1974 4 3


How to calculate how many red in 1974. In this case the formula previously
given formula gives 0 as a result. How to solve this?

(The result should be 8)

Thanks!

tom



Don Guillett said:
=SUMPRODUCT((A2:A18="john")*B2:C18)

--
Don Guillett
SalesAid Software
(e-mail address removed)
tom ossieur said:
Hi! Thanks for the answers!

still encountering problems with SUMIF. The actual table contains sevrel
colums with data.

an example:

A B C
1 green red
2 John 4 2
3 Fred 1 3
4 Eric 111 1
5 Eric 5 3
6 John 5 4
7 Eric 5 2
8 Fred 5 2
9 Eric 5 1



=SUMIF(A2:C9,"John")

The result is 0, how to get 2+4=6 as a result?

Thanks a lot!

tom


Dave F said:
=COUNTIF([range],"Eric") --> replace [range] with the correct range on
your
worksheet.

=SUMIF([range],"Eric") --> replace [range] with the correct range on your
worksheet.
--
Brevity is the soul of wit.


:

Hi!

given the table below - example -

John 2
Fred 3
Eric 1
Eric 3
John 4
Eric 2
Fred 2
Eric 1

1. I want to count how often a name occurs
e.g. Eric = 4

2. I want to calculate the sum of the values for a certain person
e.g. Eric = 7

Any solution?

Thanks!

tom
Click to expand...
Click to expand...
Click to expand...
 
sorry, seems now it works.. thanks anyway!

tom ossieur said:
Thanks a lot!

next step makes it more complicated..
given a list of years instead of names.

A B C
green red
1 1974 2 2
2 1985 6 1
3 1983 2 3
4 1974 1 3
5 1983 2 1
6 1974 4 3


How to calculate how many red in 1974. In this case the formula previously
given formula gives 0 as a result. How to solve this?

(The result should be 8)

Thanks!

tom



Don Guillett said:
=SUMPRODUCT((A2:A18="john")*B2:C18)

--
Don Guillett
SalesAid Software
(e-mail address removed)
tom ossieur said:
Hi! Thanks for the answers!

still encountering problems with SUMIF. The actual table contains sevrel
colums with data.

an example:

A B C
1 green red
2 John 4 2
3 Fred 1 3
4 Eric 111 1
5 Eric 5 3
6 John 5 4
7 Eric 5 2
8 Fred 5 2
9 Eric 5 1



=SUMIF(A2:C9,"John")

The result is 0, how to get 2+4=6 as a result?

Thanks a lot!

tom


:

=COUNTIF([range],"Eric") --> replace [range] with the correct range on
your
worksheet.

=SUMIF([range],"Eric") --> replace [range] with the correct range on your
worksheet.
--
Brevity is the soul of wit.


:

Hi!

given the table below - example -

John 2
Fred 3
Eric 1
Eric 3
John 4
Eric 2
Fred 2
Eric 1

1. I want to count how often a name occurs
e.g. Eric = 4

2. I want to calculate the sum of the values for a certain person
e.g. Eric = 7

Any solution?

Thanks!

tom
Click to expand...
Click to expand...
Click to expand...
 
glad to help

--
Don Guillett
SalesAid Software
(e-mail address removed)
tom ossieur said:
sorry, seems now it works.. thanks anyway!

tom ossieur said:
Thanks a lot!

next step makes it more complicated..
given a list of years instead of names.

A B C
green red
1 1974 2 2
2 1985 6 1
3 1983 2 3
4 1974 1 3
5 1983 2 1
6 1974 4 3


How to calculate how many red in 1974. In this case the formula
previously
given formula gives 0 as a result. How to solve this?

(The result should be 8)

Thanks!

tom



Don Guillett said:
=SUMPRODUCT((A2:A18="john")*B2:C18)

--
Don Guillett
SalesAid Software
(e-mail address removed)
Hi! Thanks for the answers!

still encountering problems with SUMIF. The actual table contains
sevrel
colums with data.

an example:

A B C
1 green red
2 John 4 2
3 Fred 1 3
4 Eric 111 1
5 Eric 5 3
6 John 5 4
7 Eric 5 2
8 Fred 5 2
9 Eric 5 1



=SUMIF(A2:C9,"John")

The result is 0, how to get 2+4=6 as a result?

Thanks a lot!

tom


:

=COUNTIF([range],"Eric") --> replace [range] with the correct range
on
your
worksheet.

=SUMIF([range],"Eric") --> replace [range] with the correct range on
your
worksheet.
--
Brevity is the soul of wit.


:

Hi!

given the table below - example -

John 2
Fred 3
Eric 1
Eric 3
John 4
Eric 2
Fred 2
Eric 1

1. I want to count how often a name occurs
e.g. Eric = 4

2. I want to calculate the sum of the values for a certain person
e.g. Eric = 7

Any solution?

Thanks!

tom
Click to expand...
Click to expand...
Click to expand...
 
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

If Functions for multiple words 10
Scrabble Value calculation for Welsh words 0
Need an Excell function that can lookup vertical AND horizontal 3
Scoring a result in a cell 4
Breaking out data 3
Formula for producing one list from another ! 2
count if with multi arguments 1
Producing an automated list from a larger list 2

Back
Top