Looking formula that SUM values with specific value in neighboring colum

A

AA Arens

Hi,

I am looking for a formula that totals (SUM) values from column B with specific value in the neighboring column A, chosen from Data Validation - List:


A B

tree 5
home 4
pole 9
home 3

Totals:
total tree 5
total home 7
total pole 9


Thank you, Bart
Excel 2013
 
C

Claus Busch

Hi Bart,

Am Thu, 1 May 2014 22:34:51 -0700 (PDT) schrieb AA Arens:
A B

tree 5
home 4
pole 9
home 3

Totals:
total tree 5
total home 7
total pole 9
Click to expand...

try it with
=SUMIF(A:A,A1,B:B)
or with a PivotTable


Regards
Claus B.
 
A

AA Arens

Hi,



I am looking for a formula that totals (SUM) values from column B with specific value in the neighboring column A, chosen from Data Validation - List:





A B



tree 5

home 4

pole 9

home 3



Totals:

total tree 5

total home 7

total pole 9





Thank you, Bart

Excel 2013
Click to expand...

Thans you claus. The formula works with my data.
 

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

How to list cells from two sheets that has different values in theirneighboring column? 8
Two Totals from the same column 2
Macro that copies values from column A (from formula) to B (paste value) 1
Looking for the value that indicates last row number that has filled cells 3
Can I select cells 3 columns away from a value in a line 3
Can EXCEL list amounts that, when added, total to a specific value? How? 5
Excel Sum with Filter & Copy specific Data 3
how to find the sum of certain values in a column. 6

Top