Formula For Excel - Xls Download

gurgur

assume
A B
1 Ram 15
2 Sham 18
3 Rohit 10
4 Ram 10
5 Ram 12
6 Sham 8
then i want sum of marks of Ram of B column i.e
C D
Ram 37(15+10+12)
Sham 26(18+8)
Rohit 10

A.S.Senthil kumar

Dear gurgur,
Please find the attached excel sheet for your query. I have understood your query as you want to add the marks secured by Ram, Sham & Rohit .
Hope it is useful for you else explain your query in detail.
Regards,
Senthil

1 Attachment(s) [Login To View]

onlyforpawan

thank you A.S.Senthil kumar for help and through this i learn something new here!!!!
i have edit something here a new improved excel sheet . it useful when these data ll on large amount .
please find attachment and let me know its useful or not !!!!

1 Attachment(s) [Login To View]

amit.dharmadhikari

Very Good Senthil... here we came to know the usage of sumif formula... earlier we have just heard it

A.S.Senthil kumar

Dear Pawan Kumar,
Your new improved excel sheet seems to be good and helpful for large entries...
Regards,
Senthil

s_kthakur

Enlosed herewith .xls file regarding ur query
plz. See

1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute