Summing some of the values in a table in Excel.
Posted on 2011-03-22
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.