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

Help Studio
, ,
1

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

2

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

3

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

4

it is saying new users cant upload attachmentsā€¦

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

5

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
6

Attached solution. It uses hasib08ā€™s solution, but you use .Length instead of .Count.

Processusvierge.zip (20,7 Ko)

1 Like
7

Hey @Anthony_Humphriesā€¦Got the answerā€¦thanks

1 Like
8

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

9

Attached a solution for getting the count based on rows.

Processusvierge.zip (26,4 Ko)

2 Likes
10

Thanks

11

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