Thread: Find certain "Text" in a specific coloum, add corres. values
View Single Post
  #2  
Old June 6th, 2010, 05:39 AM posted to microsoft.public.excel.misc
L. Howard Kittle
external usenet poster
  
Posts: 516
Default Find certain "Text" in a specific coloum, add corres. values
Try =SUMIF(C1:C3,"A",D13)

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

HTH
Regards,
Howard

"Arum Khan" Arum wrote in message
...
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