Announcements
i have a student table in excel sheet and I am using this formula (CountIf(Attendance,Status="Present" && 'Name '=Gallery5_1.Selected.'Name ')) to count the number of students based on their status which is "present" inside of a gallery. but it does not work correctly. So, could someone help me please.
Hi!
Referencing Gallery5_1.Selected will just reference the item in the gallery you have selected - the top one by default.
Since this is a text box inside the gallery, try something like:
CountIf(Attendance,Status="Present" && 'Name '=ThisItem.'Name ')
Hope this helps!
Thank you so much it works now.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 762
11manish 640
Valantis 548