Hi... (Sorry, I can't explain in title)
In here also... I have data in 3 sheets , then I want consolidate the total based on some classification .. (please download my attachment ) what are the formulas I need to use. pls. guide Me...
[C.xlsNo. of students got A1,A2,A3... in suitable column]