Index to determine total of values

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

Guest

Bob 1
Bob 3
Jill 2
Jill 1

How do I get excel to calculate the total value for Bob and Jill. I have
tried index, but cannot get the formula correct.
 
=SUMIF(A1:A20,"Bob",B1:B20)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

How to search and replace cells 0
Reconstructing a table 4
Extract unique values 3
Scrabble Value calculation for Welsh words 0
can formula to read sheetname from a cell? 2
Contains a Value Cell and Sumif? 4
Pivot Table Totals 1
Extract unique values 2

Back
Top