Try this formula in C1:

=SUMIF(A1:A10,"1.882.005",B1:B10)

This looks at rows 1 to 10 - adjust the ranges to suit your data.

Hope this helps.

Pete

On Apr 10, 4:00 pm, juanpablo
wrote:
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