Attendence sheet me present OR ABSENT KO COUNT KARNY KIA FARMULA BATA DEY PLEAZZZZZZZZZZZZZZZZ
Attendence sheet me present OR ABSENT KO COUNT KARNY KIA FARMULA BATA DEY PLEAZZZZZZZZZZZZZZZZ
Just use counif function
for present
=countif(range,"P")
as per your sheet
=COUNTIF(B5:L5,"P")
for absent
=countif(range,"A")
as per your sheet
=COUNTIF(B7:L7,"A")
may be this will hlep you.
regards
Syar is rite
syar thanx mera kaam ban gya
syar ap ki post achi he per is me mujh ko ek problam hy
k is attendance sheet me weekly off ko count kese karo present k sath
kia esa hu sakta hey
salam::
kia aik he cell m ya alag.
and see also the attached sheet if this can help you.
tank u sayr ap ka buhot shukrya mera problam solve ho gya
and thanx to it dunya
Ok.ans ap ko mil gia hy.
بھت عمدہ
"Everybody in this world loves you for his own interest. Only ALLAH Loves you for your interest."
Nice help
Bookmarks