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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Formula help

Please could some one help me out? Iv worked out how to do the formulas for both totalling the check mark and the number of adults or children. But what I really want is to be able to have have for mail a that adds up the number of ‘checked’ adults coming to the party as well as the number of checked children. Whilst all I’m getting in the red exclamation mark, or just the total of ‘checked’ people added onto the number or adults or children. If that makes sense. 🙈

iPhone 13 Pro Max

Posted on Jan 8, 2023 4:02 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 8, 2023 4:36 AM

You can try COUNTIFS, something like this:



=COUNTIFS(Gregs::C,TRUE,Gregs::D,A2)


More on COUNTIFS here:


COUNTIFS - Apple Support


SG


2 replies

Formula help

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