Looking formula that SUM values with specific value in neighboring colum

  • Thread starter Thread starter AA Arens
  • Start date Start date
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
 
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.
 
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.
 
Back
Top