View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
juanpablo juanpablo is offline
external usenet poster
 
Posts: 108
Default Help with Formula

Hi,
I want to create a formula that looks up in column A for example
'1.882.005', if found then add all the data for coulmn B that contains
1.882.005 and put in in cell C1 for example.

COLUMN A COLUMN B
1.882.005 188
1.882.005 27
1.882.005 198
1.882.005 53
1.882.005 47
2.636.119 40
2.636.119 4
3.331.634 4
3.331.634 5