How to count number of present and absent students from excel?

I hv d excel sheet of students info there is one col called attendence i want to count no of prenet and absent students?

It depends on how your Excel workbook is structured. Can you post an example workbook?

Can you send some dummy excel , so that we can tell you the solutions.

it is saying new users cant upload attachments…

Name,Marks,Attendence
Aparna,88,Present
Shradha,67,Absent
Harsh,99,present…like dat only

Use select query to get the count of Absent and Present

Datatable.Select("[Column_Name]=‘Absent’").Count
Datatable.Select("[Column_Name]=‘Present’").Count

Thanks
@aparna3010

3 Likes

Attached solution. It uses hasib08’s solution, but you use .Length instead of .Count.

Processusvierge.zip (20,7 Ko)

1 Like

Hey @Anthony_Humphries…Got the answer…thanks

1 Like

Actually the excel is like this

Student Name,1st feb,2nd feb,3 rd feb,4th feb,Total A,Total P
Aparna,A,A,P,P
Shradha,A.P,A,P
harsh,P.P.,P,A

Attached a solution for getting the count based on rows.

Processusvierge.zip (26,4 Ko)

2 Likes

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.