Find Values in Excel Document and add together

  • Thread starter Thread starter Mona
  • Start date Start date
M

Mona

How do I find all the values for Russ in a spreadsheet and add them together?

Example:

Russ 1
Sally 2
Adam 3
John 4
Russ 5
Sally 2
Adam 3
Russ 5

Without sorting by Russ and then adding together, is there a formula where I
can tell it to find all the Russ' and add them together for me?
 
Hi Mona,

You've asked this Excel question in a newsgroup for Access, the Microsoft
database product. You should be asking in one of the micrsoft.public.excel
groups.

That said, the answer is to use the SumIf function. Assuming that your
sample data is in columns A and B, rows 1 to 8, the following formula will
do it:
=SumIf(A1:A8,"Russ",B1:B8)

HTH,

Rob
 
Mona said:
How do I find all the values for Russ in a spreadsheet and add them
together?

Example:

Russ 1
Sally 2
Adam 3
John 4
Russ 5
Sally 2
Adam 3
Russ 5

Without sorting by Russ and then adding together, is there a formula where
I
can tell it to find all the Russ' and add them together for me?
Click to expand...
 

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

Scrabble Value calculation for Welsh words 0
Lookup or If, then Question 1
Summarizing data 2
reflecting values in a column into a row 1
Vlookup, IF, concantenate, Right -- can all these be in one formu 6
Can my '07 Access or Excel compare values, then calculate them? 11
I am trying to use the IF and SUMIF function on Excel 8
Re: Names appearing with unwanted single quotes 0

Back
Top