Formula For Excel - Xls Download

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
14th August 2012 From India, Jalandhar

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

14th August 2012 From India, Madras

Attached Files (Download Requires Membership)

Excel formula.xls (24.0 KB, 3137 views)

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 !!!!
14th August 2012 From India, Mumbai

Attached Files (Download Requires Membership)

Excel formula 1.xls (34.0 KB, 2156 views)

Very Good Senthil... here we came to know the usage of sumif formula... earlier we have just heard it
15th August 2012 From India, Mumbai

Dear Pawan Kumar, Your new improved excel sheet seems to be good and helpful for large entries... Regards, Senthil
16th August 2012 From India, Madras

Enlosed herewith .xls file regarding ur query plz. See
16th August 2012 From India, Delhi

Attached Files (Download Requires Membership)

QUERRY REPLY 2 METHODS.xls (22.0 KB, 1032 views)