Need help for excel

[asif35]

Assalam O Alaikum
Koi Excel expert bahi mujy bata sakta hai k agar kisi colum mein alag alag line mein number hon aur kisi ko ek number malom hai magr wo ye nhi janta k kin kin number ko plus karne se wo banta ho too excel mein kaise maloom kiya ja sakta hai???? example: colum A mein 2,3,4,5,6,7 aur aap malom karna chahte hain k kin ko plus karne 8 banta hai too es k leay konsa farmula istemal ho ga k ye colum B mein 2 aur 6 aur colum C mein 3'aur 5 k agey tick lag jae???

[My Heaven]

Assalam O Alaikum
Koi Excel expert bahi mujy bata sakta hai k agar kisi colum mein alag alag line mein number hon aur kisi ko ek number malom hai magr wo ye nhi janta k kin kin number ko plus karne se wo banta ho too excel mein kaise maloom kiya ja sakta hai???? example: colum A mein 2,3,4,5,6,7 aur aap malom karna chahte hain k kin ko plus karne 8 banta hai too es k leay konsa farmula istemal ho ga k ye colum B mein 2 aur 6 aur colum C mein 3'aur 5 k agey tick lag jae???

Interesting sawal hai
Wait for experts

Sent from my QMobile i1 using Tapatalk

[yasirashraf1]

if you want to plus any of numbers here is formula
=SUM(A1,B1,C1,D1,E1)

[asif35]

Nahi bahi ye too malom hai mujy ye pata karna hai k agar kisi ko (total) numbr ka ye dekhna ho k ye Colum k kin kin numbr ko plus krne se wo total banta hai.

[Refan]

Swal to app ka bahut interested hai..
mujy jitna samjh aya main file bana kar send kardi hai
main screen shot attached kiya hain ...

[asif35]

bahi ye es mein too aap ko malom hai na C8+C5 se 9 answer aata hai. Mujy ye pochna hai k koi aisa formula ho jo ki dusre colum mein likha jae aur C3 se C10 tak select kren too C8 aur C5 k aagy kuch nishani aa jae.

[syar]

Aap excel ka add-in solver use karain aap ka masla hal ho jay ga. Excel k optiin m jain. Wahan p, adds-in select krain aur solver ko select kr k kr dain. Phr ise use karai. Aap ko use krne m masla ho tu rply.
Excel solver aap ko sirf aik possible combination batay ga.
Regards,

[sajidbagi]

check this sheet

[sajidbagi]

Dear Bro try this workbook i have created for u