Adding #s relating to an entry

  • Thread starter Thread starter elitehak
  • Start date Start date
E

elitehak

Hello everyone,

Need some help on a function.
This is what i have

Column A Column B

Remelie 10
Jas 2
Ray 5
Remelie 7
total 24

I want a function that will search in column A for all
entries called "remelie", and when it finds them, i want
the function to add the corresponding entries in column B.
For example, i want a function that will tell me the
total of all entries in colum B associated to "remelie"
in column A. In my example above, it would be 10+7= 17

Any help is appreciated,

Eli
 
Hi Eli!

Here's one way:

=SUMIF(A1:A5,"REMELIE",B1:B5)

To make this even more versatile, use a cell reference in
place of "Remelie". Enter Remelie in say cell C1. Then the
formula looks like this:

=SUMIF(A1:A5,C1,B1:B5)

Biff
 
Back
Top