Sum the results of a lookup

  • Thread starter Thread starter JimmyHack
  • Start date Start date
J

JimmyHack

Is there a way to use lookup to sum the values of the result vector?

Here's what I need. In column A there are a list of letters. I
column B there are a list of numbers. I want a formula that will loo
up a particular letter and it's corresponding numbers and sum th
total.

If in column A the letter "s" is listed 3 times with correspondin
numbers of 1,2 and 3. The formula used result in "6".

Does this make any sense? Is it doable?

Thanks for any help,
JimmyHac
 
use a sumif formula =sumif($a:$a,"s",$b:b$)

Where $a:$a is where the 's' is and $b:$b is where the numbers to b
summed are...
 
Back
Top