Help using if condition and vlookup

S

saraskandan

Hi ...

I have set of values in a column. using the if condition i need to
lookup the values from one column and match with another column with
adding up values

for eg.,

Name Value
A 25
B 15
A 15
B 30
C 20
D 25
C 10

please help in finding a solution using ISNA
 
B

Bob Phillips

I think you mean

=SUMIF(A:A,"A",B:B)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top