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

Help with Formula
 

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

Help with Formula
 

Thanks I totally forgot about that formula.

One more thing.

If I want to look for '435' in Column B and if found then extract the
correspondent value from column A 'X', and return it, for example, on a cell
C1?

COLUMN A COLUMN B
X 435
Y 719
Z 135
W 524



"Pete_UK" wrote:

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

Help with Formula
 

This is a sort of reverse lookup function.
Assuming you have the headers in row 1 and the data start in row 2
=OFFSET(A1,MATCH(D2,B2:B5,0),0)
D2 is the cell where you input the key you are looking for.
Copy this formula down.
Andrea

"juanpablo" wrote:

Thanks I totally forgot about that formula.

One more thing.

If I want to look for '435' in Column B and if found then extract the
correspondent value from column A 'X', and return it, for example, on a cell
C1?

COLUMN A COLUMN B
X 435
Y 719
Z 135
W 524



"Pete_UK" wrote:

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