Attandance sheet

step-1  select all  table

Home menu > format

 colum width

 choose any no.

step -2  पुरी  sheet में जहां-जहां  absent mark करने हैं वह करें

step -3   select table only 1-31 days ( row / column)

step - 4  Home > find & select > Replace > Replace with :p> Replace all

Note-  absent को Heghtight  करने के लिए  conditional formatting > Highlight cell Rules > Equal to - 'A' choose colous.

step-5  present value निकलने के लिए

= countif (range of present or absent,"p")

step-6  Absent value

=countif (range of present or absent "A")