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
From India, Jalandhar
A.S.Senthil kumar
25

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

From India, Madras
Attached Files (Download Requires Membership)
File Type: xls Excel formula.xls (24.0 KB, 3177 views)

onlyforpawan
3

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 !!!!

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Excel formula 1.xls (34.0 KB, 2367 views)

amit.dharmadhikari
Very Good Senthil... here we came to know the usage of sumif formula... earlier we have just heard it
From India, Mumbai
A.S.Senthil kumar
25

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

Enlosed herewith .xls file regarding ur query plz. See
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls QUERRY REPLY 2 METHODS.xls (22.0 KB, 1069 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.