mabubakerali
New Member
- Joined
- Feb 23, 2016
- Messages
- 25
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 ?
ADVERTISEMENT
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