Solved

Summing some of the values in a table in Excel.

Posted on 2011-03-22
6
265 Views
Last Modified: 2012-05-11
Hello,

Suppose you have a table of values in an Excel (2007) spreadsheet which is 10 columns wide and many rows in length (say A3:J5000).  Furthermore, suppose that column B has only three possible entries:  D, C and W.  In other words, none of the entries in column B is unique.

Now suppose that for a specified range in the table, you want to use =SUM() to add-up all the values (but only the values) in column G which have a "D" in column B.  What formula would do that?

I am familiar with using =LOOKUP() to locate values in a list or table.  However, I believe that =LOOKUP() is only usable when all values in the lookup column are unique.  Is that correct?

If so, then here, I am looking for a function in which those values do not have to be unique.

Thanks
0
Comment
Question by:Steve_Brady
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 35191567
Hello Steve

Sounds like you'd want SUMIF, so for the whole table

=SUMIF(B3:B5000,"D",G3:G5000)

regards, barry
0
 
LVL 30

Expert Comment

by:gowflow
ID: 35191569
=COUNTIF(G1:G5000,"D")

gowflow
0
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35191577
first question: =SUMIF() would do that.
second question: not necessarily unique, but lookup will only bring one result, the first one it finds.

:)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Expert Comment

by:harr22
ID: 35191586
=SUMIF(B1:B5000,"D",G1:G5000)
0
 
LVL 30

Expert Comment

by:gowflow
ID: 35191619
pls ignore my previous post barryhoudini your correct.
gowflow
0
 

Author Closing Comment

by:Steve_Brady
ID: 35420677
Thanks Barry!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question