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.
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.
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
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...
apka question samjh nahi aaya agr screen shot lay kr bata dain tu shayed
BEST REGARDS
SYED SHOAIB
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.
alam::
suppose column a1 se a20 tak aap ki word/location lekhe huwe hain.
Method 1
B1 m ye formula lekhain
B2 m ye formula lekhainCode:=countif(a1:a20,"islamabad")
Change ranges/reference accordingly.Code:=countif(a1:a20,"abbotabad")
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
regardsCode:=countif($A$1:$A:$20,b1)
Very Very NICE and helpful
Thank You very much
Close the thread
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
salam::
can you copy your both formula as it is. Jesa ka aap sheet me istimal kar rahee hain
g builkul main aisay hi kar raha hoon woh islamabad ko sahi find kar k sum karta hai mgr abbottabad ko nahi kar raha
As i request can you copy your formula from sheet to here.
Bookmarks