<div>
=COUNTIF(G1:G5000,&quot;D&quot;)<br />
<br />
gowflow
</div>


<div>
first question: =SUMIF() would do that. <br />
second question: not necessarily unique, but lookup will only bring one result, the first one it finds.<br />
<br />
:)
</div>


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

:)

<div>
=SUMIF(B1:B5000,&quot;D&quot;,G1:G50<wbr />00)
</div>


<div>
pls ignore my previous post barryhoudini your correct.<br />
gowflow
</div>


pls ignore my previous post barryhoudini your correct.
gowflow

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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). &nbsp;Furthermore, suppose that column B has only three possible entries: &nbsp;D, C and W. &nbsp;In other words, none of the entries in column B is unique.<br />
<br />
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 &quot;D&quot; in column B. &nbsp;What formula would do that?<br />
<br />
I am familiar with using =LOOKUP() to locate values in a list or table. &nbsp;However, I believe that =LOOKUP() is only usable when all values in the lookup column are unique. &nbsp;Is that correct?<br />
<br />
If so, then here, I am looking for a function in which those values do not have to be unique.<br />
<br />
Thanks
</div>
</div>


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

Summing some of the values in a table in Excel.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.