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
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
From India, Madras
25Please 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
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
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
Very Good Senthil... here we came to know the usage of sumif formula... earlier we have just heard it
From India, Mumbai
From India, Mumbai
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.
EXCEL FORMULA.xls