Formula to pick values automatically from certain column based on values in cells of that column.

[mabubakerali]

sorry for the bad english but i have explained the best i could in above screenshot so, plz post the relevant reply!

 

[Gerald Higgins]

What should the answer be ?
Should it be 1,086,802, being the sum of entries in column G that say Imran in column A ?
I.e. 100,000 + 493401 + 493,401 ?

 

[nardagus]

Is L17 a fixed cell where you will sum things up? Then you could write this formula in L17:

=SUMIF(A:A;L16;G:G)

where:
A:A - is a range for criteria lookup. In this example it would be Imran
L16 - a cell where you could type a value you want to sum by. In this case it would be: Imran
G:G - is actually a column which will be sumed up based on a cells found by excel in range A:A

Nard

 

[mabubakerali]

What should the answer be ?
Should it be 1,086,802, being the sum of entries in column G that say Imran in column A ?
I.e. 100,000 + 493401 + 493,401 ?

yea yea, exactly what you said!

 

[Gerald Higgins]

In that case I think nardagus's suggestion will give you that.

 

[mabubakerali]

Is L17 a fixed cell where you will sum things up? Then you could write this formula in L17:

=SUMIF(A:A;L16;G:G)

where:
A:A - is a range for criteria lookup. In this example it would be Imran
L16 - a cell where you could type a value you want to sum by. In this case it would be: Imran
G:G - is actually a column which will be sumed up based on a cells found by excel in range A:A

Nard

Thanks alot for your help buddy!
This forum is awsome, always get quick and working solution of every problem!

 

[nardagus]

Glad to help.

Cheers mate.