Need to combine Sum and Count functions in a single formula

Good morning. for the following ranges G16:M16 and G17:M17, I need a formula that will count if G16+G17 is equal to or greater than 4, then counts as 1, to a max of 7. Context, farm workers log their time working on 2 different crops for the week: Monday: G16 crop 1, G17 crop 2; Tuesday H16 crop 1, H17 crop 2. I need to count how many days in the week they worked 4 hours or more per day, to a total of 7 days in a week.
This has me stumped. I can't change the format of the spreadsheet or add any additional columns because it is uploaded to a 3rd party program.
TIA

I've added an example of what I'm trying to do. Need to adjust the formula =COUNTIF(G8:M8,">=4")+COUNTIF(G9:M9,">=4") currently in cell O8

Edit #2 to indicate my issue appears to be solved. Thanks again!

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Or

Formula:

Please Login or Register  to view this content.

Is this what you mean?

=MIN(7,COUNTIF(G8:M8,">=4")+COUNTIF(G9:M9,">=4"))

How about this?

=LET(s,G8:M8+G9:M9,COUNT(FILTER(s,s>=4)))

Or a tweak of the one offered by Hans:

=SUM(N(G8:M8+G9:M9>=4))

Did you try the formula's in Post #3 and #4?

[These formulas are based on your text before you have added a sample sheet.]

In your sample sheet, this formula returns 6:

Formula:

Please Login or Register  to view this content.

Originally Posted by 2BusyGal

AliGW: when I plug it into my s/sheet and adjust for the correct row #'s, I get an error that formula isn't valid and it highlights 'FILTER'

Are you using a French locale? If you have 365, you have FILTER. This, maybe?

=LET(s;G8:M8+G9:M9;NB(FILTRE(s;s>=4)))

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Thanks for your feedback and rep . Glad to have helped.