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
 
Ad

Advertisements

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

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


Regards
Claus B.
 
Ad

Advertisements

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

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

Top