Is there any alternative to multiple COUNTIF? Over 64 nested limitation.

Hello, newish to Excel. And brand new to this forum. Apologies in advance if this is a recurring theme. Tried searching, can't find the solution. I have attached the Worksheet. What I am attempting is to get a formula to work that subtracts Annual Leave hours (cells h37 & h38), (work 4 on 4 off), putting the letter L in the relevant cell, the grey ones. The problem is, that for the first 3 days it is 11 hours & the fourth is 10 hours. Tried COUNTIF, SUM and others. It all works OK, until the sheet is saved, then, due to the 64 nesting limitations, I get an error. I have saved the formula to paste when needed, but it is a bit of a pain. The formula looks like this COUNTIF(F7:F9,"=L")*11+COUNTIF(F10,"=L")*10, but repeated many times. Wondered if I could get some help. Many thanks in advance. Jon.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Not sure exactly what you are trying to do. (filling in some example numbers with solutions might help) but
to sum the values in F4:F34 which contain L and multiplying every 4th one by 10 with the others by 11 can be done with this Arrayed formula. (Use CNTRL SHFT ENTER instead of ENTER. You'll see {} around your formula if done properly)

=SUM(IF($F$4:$F$34="L",IF(MOD(ROW($F$4:$F$34),4)=3,10,11),0))
Does that help?