Excel Formula needed

[Shoaibm]

Hi Every body
I want a excel formula of sum but this the differnet formula then sum.


I want a fromula of sum when is enter no 1 and after hitting the enter button the number add to the total cell and the 1 loaction will showing empty.


Thanks

[syar]

agar mera andaza drust ha tu read the below thread. may be this will help u

http://www.itdunya.com/t309052/

regards

[Shoaibm]

Not exectly that
Mery pass aik sheet thi jis mein english k words type karen to woh us ko 1,2,3 mein count kar laita that mein aisa formula chahta hun k mein sum ka formula jis row pey lagaon us row mein 1 lkh kar enter karon tou woh total mein add ho jay aur jis cell mein 1 likha hey woh yah tou blank ho jaye yah 0 show karey

[*Noor-ul-Ain*]

Aisa Possible nahi hy k wo zero show ho. han ap us ko hide kar skty hein.

[Shoaibm]

Koi farmula hey aap ki pass?

[IT.BOY]

محترم آپ ایک عدد ایکسل کی شیٹ پر چھوٹا سے فارمیٹ بنا کر یہاں پر اسکرین شارٹ دے دیں کہ آپ کیا کرنا چاہتے ہیں۔۔۔
ہم کوشش کریں گے فارمولا ایڈ کرنے کی۔۔۔اوکے

[justali]

Dost ager ap is tarhan chaty ho to example di hai chek kar lena or ager ye nahi hai to ek example bana k screen shot ya file attached kr k do ta k ap ki pro blem solve ho saky



sum solved.xls