Excel Formula

[mohsinyounis]

Mjy Excel ka formula chahiay

Find and sum

pehly values (alphabetics same values) ko find kary phir un ko sum kary aik hi column main hain.

[mohsinyounis]

Mujy boht zaruri kaam krna hai agr kisi ko pta hai to please jaldi say bta dain main thread k reply ka intizar kr rha hoon

[umer_what]

I think yeh ap ki madad ker sakta hy

" Sum all digits occuring in text string" yeh wala page ap ki help ker sakta hy...

[syedshoaib]

apka question samjh nahi aaya agr screen shot lay kr bata dain tu shayed

[mohsinyounis]

excel main 10 martba abbottabad likha hai 10 martba islamabad likha hai.
ab main chahta hoon k pehly abbottabad ko find kary r phir mujy sum kar ky btay k abbottabad 10 martba likha hwa ha.

[syar]

alam::

suppose column a1 se a20 tak aap ki word/location lekhe huwe hain.

Method 1

B1 m ye formula lekhain

=countif(a1:a20,"islamabad")

B2 m ye formula lekhain

=countif(a1:a20,"abbotabad")

Change ranges/reference accordingly.

Method 2
B1 aur B2 m apna criteria lekhain jis ko apne count karna ha for example "islamababd","abbotabad"
c1 m ye formula lekhain aur copy down

=countif($A$1:$A:$20,b1)

regards

[mohsinyounis]

Very Very NICE and helpful

Thank You very much

Close the thread

[mohsinyounis]

Thank You Syar Bhai
lakin method NO-1 main problem yeh hai k sirf Islamabad ko find karta hai lakin jab main yahi formula abbottabad keliay lgata hon to values show nahi karta, and Method 2 kam hi nahi kar raha

[syar]

salam::

can you copy your both formula as it is. Jesa ka aap sheet me istimal kar rahee hain

[mohsinyounis]

g builkul main aisay hi kar raha hoon woh islamabad ko sahi find kar k sum karta hai mgr abbottabad ko nahi kar raha

[syar]

As i request can you copy your formula from sheet to here.

[mohsinyounis]