syar said:
salam::
Suppose agar aap b9 main student ka Sr. No. enter karte hain tu try follwoing
Admission Fee k leye
=SUMPRODUCT(--(Sheet2!$A$2:$A$100=Sheet1!B$9),--(Sheet2!$c$2:$c$100="yes"),--(Sheet2!$h$2:$h$100))
Annual ex kleye
=SUMPRODUCT(--(Sheet2!$A$2:$A$100=Sheet1!B$9),--(Sheet2!$c$2:$c$100="yes"),--(Sheet2!$i$2:$i$100))
Tution fee k leye
=SUMPRODUCT(--(Sheet2!$A$2:$A$100=Sheet1!B$9),--(Sheet2!$c$2:$c$100="yes"),--(Sheet2!$j$2:$j$100))
aap akhri condition main column ka name badalte jain.
Leekan agar aap chahte ho k sirf aik he formula likhon aur is ko copy down aur across karne par aap ko matloba result mil jae tu is k leye zaroori ha ka aap k sheet 2 main column ka name challan form main name aik jaise hon. Kia aap aisa kar sakte hain? agar yes then reply.
regards
Bookmarks