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

ryszardb Author

Level 1

4 points

Countif ?

I try to calculate number of checkbox with countif, but it does not work.

Mac mini, iOS 11.4.1

Posted on Nov 1, 2018 3:39 AM

Reply

Best reply

Level 7

20,401 points

Posted on Nov 1, 2018 4:15 AM

Hi ryszardb,

Does COUNTIFS do what you want?

Formula in Table 1 Cell F2 = COUNTIFS('2018 / 2019'::A,A2,'2018 / 2019'::C,"TRUE")

Test Values, Condition, Test Values, Condition...

Regards,

Ian.

View in context

Similar questions

2 replies

Best reply

Level 7

20,401 points

Nov 1, 2018 4:15 AM in response to ryszardb

Hi ryszardb,

Does COUNTIFS do what you want?

Formula in Table 1 Cell F2 = COUNTIFS('2018 / 2019'::A,A2,'2018 / 2019'::C,"TRUE")

Test Values, Condition, Test Values, Condition...

Regards,

Ian.

Reply

ryszardb Author

Level 1

4 points

Nov 1, 2018 4:15 AM in response to Yellowbox

Thanks!!! Ian

Exactly what I need.

Ryszard

Reply

Countif ?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up