Google-sheets – How to a forumula be converterd to array formula in Google Sheets

It looks like the correct countif formula is in your reports sheet right now - but in answer to your comment - if you want to simplify that huge if statement, you can use arrayformula, and vlookup or substitute to trim the formula to this:

=if(istext(B2), SUM(ARRAYFORMULA(VLOOKUP(R2:AD2,{"Not at all",0;"To a slight degree",1;"To a moderate degree",2;"To a great degree",3;"All the time",4},2,FALSE))),)

for my example i gave it a short lookup table, but i included it as a literal array so that you dont have to create a helper column

or

Use TEXT function to format the month column. Your array formula would change to:

=ARRAYFORMULA(IF(A8:A <> ""; YEAR(A8:A) & "/" & TEXT(MONTH(A8:A);"00"); ""))