hi all,
please help
REF is the name of the range A5:A10, it's items are the following
A5=123.a
A6=45.b
A7=22.b
A8=19.a
A9=25.a
A10 is blank
the formula =sumproduct(--left(REF,find(".",REF)-1)) gives an error
#VALUE! if any cell of the range is blank.
is there a way to solve this problem
with many thanks