A B C D E F
1 0 0 7.75 7.75 7.75

2 LA H

3

4

5 ?

6


For a formula in cell F5, how can I recognize the text "LA", "PD",
or "EA" (or any other text), excluding the text "H". Then, if A2:E2
has the specified text (excluding "H"), to replace the 0 that is
associated with it (from cells A1:E1) with another number (such as 7,
but not putting this number into cells A1:E1), then adding up all of
the cells with 7 and putting this number in cell F5. Also, when adding
up the 7's, the formula should not recognize the 7 from the 0 that is
associated with the text "H".
I know this is an intricate problem and the person who can solve it
is truly an Excel master. I would appreciate any suggestions. Thanks!!