Calculating count of absence and presence

[rpajyoti_wagh (jyoti wagh)]

Hey guys plz help me wid this scenario…
In this attendance sheet., We need total of present and absent days in last column.
How can we get that???

[supermanPunch (Arpan)]

@rpajyoti_wagh It would be Good if you Show us the Excel File, or give a Sample Excel File in the way you decribed it. You don’t Actually need to Draw the Excel Data , Sample Data is fine.

[ImPratham45 (Prathamesh Patil)]

Try This hope it will help
attend.xaml (14.3 KB) attend.xlsx (8.2 KB)

[rpajyoti_wagh (jyoti wagh)]

Hey Thank you @ImPratham45

[ImPratham45 (Prathamesh Patil)]

Welcome!

Happy Automation…

Prathamesh Patil

[rpajyoti_wagh (jyoti wagh)]

Thank you prathmesh… work zala programme… output aal

[ImPratham45 (Prathamesh Patil)]

Mast mast

[rpajyoti_wagh (jyoti wagh)]

[Nithin_P (Nithin Prabhu)]

Please Mark the reply that helped you the most as the solution. This will help the others in our community.

Regards,
Nithin