i wish to lookup values in column A, & add adjacent values in colu

  • Thread starter Thread starter Browny
  • Start date Start date
B

Browny

i wish to lookup values in column 'A' and sum the adjacent column(B)
eg.

A B
1 1 120
2 2 50
3 1 120
 
Try this:

=SUMIF(A1:A3,1,B1:B3)

Or, use a cell to hold the criteria:

D1 = 1

=SUMIF(A1:A3,D1,B1:B3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup value in one column & add the values in adjacent columns 3
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Date Lookup 8
Sum / Lookup 9
lookup options 2
how do i add in numbers automatically based on adjacent cells cont 2
lookup using column headers and row headers 1
Counting unique values in multiple columns 4

Back
Top