There's probably a better way, but I would add a field at the bottom of each column with a flag identifying if the column has 1, 2 or 3 in it. Then simply total the row. For instance A26 would contain "=if(countif(A1:A24,"<4"),1,0)". Copy this thru remaining 7 columns (B:H)

The 9th column (say I26) would contain a field with "=SUM(A26:H26)"

I am sure there is a more elegant method but this will work.

Good luck.