hi, !

Hi, Hector. I wrote before;
" When I have an L in the same line with LE, formula goes #VALUE!. The formula
works well with other letters in the same line but not beginning with the
same one. Example:
19.....L3 L2.5 LE7.5 LE7.5 LE7.5 LE7.5 LE7.5 H = VacationL 5.5

the formula should sum L3 + L2.5 and disregard for VacationL Totals those LEs."
I change the 2 number in SUMPRODUCT(IF(LEFT(C19:N19,2)="l", by one but just shows "0" on total.
I wipe up those numbers beside the letters LE but doesn't make any changes. I have no hint of how to get it better ...

formula in Q column becomes an array-formula :-((

[Q19] =countif(c19:n19,"l")*7.5+sum(if(isnumber(--substitute(lower(c19:n19),"l",0)),--substitute(lower(c19:n19),"l",0)))

or, from the beginning...

[Q3] =countif(c3:n3,"l")*7.5+sum(if(isnumber(--substitute(lower(c3:n3),"l",0)),--substitute(lower(c3:n3),"l",0)))

please, consider that only you have the TOTAL (possible) combinations of letters & numbers

as I said...
"please, revise and adapt/modify suggested array-formula in [R3] according other "expected" representation (letters & numbers)"
and...
"p.s. don't forget what you just learned in "Hints and Tips for New Posters" ;)"

regards,
hector.