Find certain "Text" in a specific coloum, add corres. values

A

Arum Khan

Hi,
I have two coloums. One has text and the other has Values.
I need excel to search through a whole coloum, and summerize the results.
My coloums look like as follows

A 2
B 5
A 2

The results should look like

A 4
B 2

How can I achieve this?
Thanks
 
L

L. Howard Kittle

Try =SUMIF(C1:C3,"A",D1:D3)

This is quite expandable using sumproduct for a criteria in B and matching
in C and then sum C.

HTH
Regards,
Howard
 

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