Attendence sheet KA PROB HEY ??????

[shehbaz_haseeb]

Attendence sheet me present OR ABSENT KO COUNT KARNY KIA FARMULA BATA DEY PLEAZZZZZZZZZZZZZZZZ

[syar]

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

[Gream]

Syar is rite

[shehbaz_haseeb]

syar thanx mera kaam ban gya

[mohibb-e-wattan]

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

shukria syar brother aap na to mare b aak mushkil hel ker de.......

[shehbaz_haseeb]

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

[syar]

salam::

kia aik he cell m ya alag.

and see also the attached sheet if this can help you.

[shehbaz_haseeb]

tank u sayr ap ka buhot shukrya mera problam solve ho gya
and thanx to it dunya

[asghar qaisrani]

Ok.ans ap ko mil gia hy.

[amiraziz]

ok.ans ap ko mil gia hy.

السلام لکم بھا جان آjjjj

[bilal_hm]

بھت عمدہ

[Ganxtr]

Nice help