I am trying to sum part of a cell and group by the initial letter of that
formula.
Example - data in cells A1 to G1 as follows:
h7.5 s5 blank cell h7.5 s7.5 blank cell h10.5
I would like to sum all numbers that have a pre-fix of "h" in their cell.

Thanks.
--
PK wilts