Check box = TRUE if all other check boxes = TRUE

[Padm0]

Hiya,

I've got a chart with check boxes in cells M2, M5, M8, and M11. Once all of those are marked as TRUE, I'd like M1 checkbox to mark itself as TRUE also.

Thanks!

 

[hagia_sofia]

Hello, which version of Excel are you using?

 

[Padm0]

Hello, which version of Excel are you using?

16.86 for Mac

 

[hagia_sofia]

So, how about:

=SUM(--(TOCOL(M2:M11,1)))=4

 

[Padm0]

So, how about:

=SUM(--(TOCOL(M2:M11,1)))=4

That's beautiful. Thank you!!