You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Count and sum cells with a specific content

I know this is an easy one for you geeks.

I have a list of students. I wanna track their assiduity to my classes.

In the column next to their name, I write "a" when they attend, or "x" when they don't.

I need a function, able to count all "a"'s as "1" and add them up, in order for me to know how many classes each student attended.


Here's how it should look like.


Thanks in advance!

MacBook Pro 13″, macOS 14.6

Posted on Sep 13, 2024 2:31 AM

Reply
1 reply

Count and sum cells with a specific content

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.