Summing values in a table
 

I have the following table:

A 1
B 2
C 3
D 4
A 5
B 6
C 7
A 8
A 9
A 10
D 11
D 12
C 13
B 14

With the text in column A & the numbers in Column B. The Letters can
change, depending on what has been entered elsewhere.

What I want to do, is calculate the sum of all entries that have a
score of A. In the exmaple of the table above, this would be 33. If
I wanted to know the sum of all entries with a score of B, it would
return 22 etc.

Can anyone help?

Rgds

Duncs

Summing values in a table
 

=SUMIF(A1:A100,"A",B1:B100)
or
=SUMIF(A:A,"A",B:B)
best wsihes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Duncs" wrote in message
ps.com...
I have the following table:

A 1
B 2
C 3
D 4
A 5
B 6
C 7
A 8
A 9
A 10
D 11
D 12
C 13
B 14

With the text in column A & the numbers in Column B. The Letters can
change, depending on what has been entered elsewhere.

What I want to do, is calculate the sum of all entries that have a
score of A. In the exmaple of the table above, this would be 33. If
I wanted to know the sum of all entries with a score of B, it would
return 22 etc.

Can anyone help?

Rgds

Duncs

Summing values in a table
 

try
=sumif(A:A."A",B:B)
etc


"Duncs" wrote:

I have the following table:

A 1
B 2
C 3
D 4
A 5
B 6
C 7
A 8
A 9
A 10
D 11
D 12
C 13
B 14

With the text in column A & the numbers in Column B. The Letters can
change, depending on what has been entered elsewhere.

What I want to do, is calculate the sum of all entries that have a
score of A. In the exmaple of the table above, this would be 33. If
I wanted to know the sum of all entries with a score of B, it would
return 22 etc.

Can anyone help?

Rgds

Duncs

Summing values in a table
 

Duncs,

=SUMIF(A2:A15,"A",B2:B15)

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Duncs" wrote in message
ps.com...
I have the following table:

A 1
B 2
C 3
D 4
A 5
B 6
C 7
A 8
A 9
A 10
D 11
D 12
C 13
B 14

With the text in column A & the numbers in Column B. The Letters can
change, depending on what has been entered elsewhere.

What I want to do, is calculate the sum of all entries that have a
score of A. In the exmaple of the table above, this would be 33. If
I wanted to know the sum of all entries with a score of B, it would
return 22 etc.

Can anyone help?

Rgds

Duncs

Summing values in a table
 

Such simple solutions!

Once again, I was trying to overcomplicate the situation.

My thanks to all for replying.

Duncs

On 16 Mar, 12:30, "Duncs" wrote:
I have the following table:

A 1
B 2
C 3
D 4
A 5
B 6
C 7
A 8
A 9
A 10
D 11
D 12
C 13
B 14

With the text in column A & the numbers in Column B. The Letters can
change, depending on what has been entered elsewhere.

What I want to do, is calculate the sum of all entries that have a
score of A. In the exmaple of the table above, this would be 33. If
I wanted to know the sum of all entries with a score of B, it would
return 22 etc.

Can anyone help?

Rgds

Duncs