Need array formulas for Countif that counts row by row and an array Mod formula

I work for a non-profit that needs to track sessions with client's. I'm hoping to utilize array formula so that when adding new clients (rows) the formula keeps auto populating. So here is the breakdown, I would like to create an array in cell b7 that will count all of the "True" / Checked boxes in each row and count them row by row and not the total across all rows if that make sense. THEN, I would like to create a arrayformula in c7 that looks at column b and notifies me (via s true false statement) if the sum of B is divisible by 6 (the clinicians need to complete a specific task every sixth sessions so I created a conditional formatting that turns the row green if the column c reads true of false).

Special requests... could your magic formulas include a condition where the value is blank if there is no client name in column D.

Included is a sample of the document in question. Please make the formula able to be carried over to google sheets as this is the platform our agency uses to collaborate on these shared documents.

I truly appreciate any help in this matter.

Can's speak for Google sheets, you'll have to check,

B7: =COUNTIFS(AE7:JN7,TRUE)
C7: =IF(MOD(B7,6)=0,TRUE,FALSE)

Use Conditional format in B7: =D7=""
and choose Font colour white

Similarly for C7

this could be accomplished with an onEdit Apps Script, instead of array formulas.

this script does NOT obey cell colouring... so black cells (B20 and C20) will have their colour changed to clear, and you will need to go back to those cells and colour them again.

heres the script:

Please Login or Register  to view this content.

and heres some slight changes to the formulas, that will keep the cell clear if the cell in column D is empty..

B7:

Please Login or Register  to view this content.

C7:

Please Login or Register  to view this content.

Steps to follow:
1. go to Extensions -> Apps Script
2. select everything in the existing base script, and overwrite with the script given above
3. save the script
4. enter the B7 formula, and hit enter, DO NOT accept the G-Sheets Autofill prompt, then wait for about 20 seconds while the script does its work and Autofills down to all other rows
5. enter the C7 formula, and hit enter, DO NOT accept the G-Sheets Autofill prompt, then wait for about 20 seconds while the script does its work and Autofills down to all other rows
6. if the script does not fill down far enough, then simply delete the formula, then enter it again, and it will push down further each time
7. recolour cells B20 and C20
8. DONE!