plz help me

[jaadoogar]

dear friends maine excell main 2 shets banai hain.
ek Nov-09 jis main ek proforma banaya hai jis main name f/name grade waghaira hain.

or dosri grand total ki hai jis main class or total students k 2 colunms banai hain.

main yeh chahta hon k sheet 1 main jo bhi entry karon to woh agar grade (Class) 1 ki ho to dosri shet k class 1 main total student k colunm main 1 add ho jae agar do entries ho to 2 show kary. ese he jis jis class ki entry karon to woh us class k agy total entries show kary.

screen shots de raha hon dono shets k.

[*MALIK*]

Meray hayal may aisa mumkin nhi kyu k eik sheet ay likhnay se dusri may data kesay ja skta hai ho skta hai k ms acsess may aisa o sakta ho

[syar]

Bhai Aap ko aik masla hal karna ho ga. K aap ki 1 sheet m grade roman m ha aur dosri ma numbers main. Agar aik jese kar sakte hain yani roman ya number tu try this on sheet 2

=countif($d$69:$d$80,b114)

adjust sheet name and ranges. Aur agar dono aik se nahee kar sakte then reply m aap ko dosra hal batata hon jo k thoda sa mushkil ho ga.
2. Dosra agar aap Name ranges par kam karna jante hain tu DYnamic Named ranges define karain taka aap ko bar bar ranges change na karne pareaur aik he bar formula apply karne se aap ka kam automatic ho gae.

regards

[jaadoogar]

dear thanks for reply. magar us formuly se 0 return ho raha hai.
or main class names roman hata ker 1 2 3 ese ker k bhi lagaya hai magar return
0 ho raha hai.
main file send ker raha hon umed hai yeh dekh ker ap meri saheh se help ker paenge.

thanks

[syar]

But the same forumla works on your sheet. see attached sheet.
Agar grade master sheet m ho ga tu count ho ga jaise 1. agar nahee ho ga tu 0 he aae ga.

regards

[jaadoogar]

But the same forumla works on your sheet. see attached sheet.
Agar grade master sheet m ho ga tu count ho ga jaise 1. agar nahee ho ga tu 0 he aae ga.

regards

buhat buhat mehirbani syar bhai.
ap sabh ki buhat help kerty hain Allah ap ko iska ajar dega. Amen.

thanks