excel help urgent

[MOuzzam shamim]

SalesMan Sales Required Target Result
Slaman 39 60 Target Not Achieved
Saad 78 50 Target Achieved
Nasir 47 40 Target Achieved
Saeed 13 40 Target Not Achieved
Faizan 60 40 Target Achieved

Total no of person who achieved target: 3 (yahn pr wo formula lagana hah jesy "result" k colum main 3 bar "target achived" likha hah tu yahn 3 likha howa hah . . agr target achieved 4 ho jyen tu automatically 4 likha ajye 5 target achieved hon tu 5 likha ajye ) pls jaldi sy koi batao

[Ghayyasg]

Brother apke problem ka solution to mjhe maloon nahe. Mgar ek mshwara hai k ap isi swal ko ek thread jiska name excel help line hai wahan post kr dain us thread me excel experts ki nazar hoti hai, apko jald hal mil jaye ga. Agar mashwara bura lgay to mazrat.

[aajizUsmani]

Agar Ap D Column Me 1 to 5 rows par kaam karana chah rahe hy yeh wala then
aisey hoga yeh
=COUNTIF(D1: D5,"Target Acheived")

[Ghayyasg]

Thats so nice.
It works. Thanx aajizusman, i learnt a new lesson from you. Superb.

[MOuzzam shamim]

Yup bro Jazak ALLAH . . . . thread closed kr do . . .

[Eng Ahtasham]

Yup bro Jazak ALLAH . . . . thread closed kr do . . .

Solved