Re: Add numbers accross columns after stripping away text

=SUMPRODUCT(--SUBSTITUTE(0&A1:F1,"f",""))
if its always "f"

"gavin" <no-one@xxxxxxxx> wrote in message
news:d6l5o2$j16$1@xxxxxxxxxxxxxxxxxxxxxxx
>I have the following data in a spread***:
>
>
>
> A1 B1 C1 D1 E1 F1
> 4.5f 6f 3.5f 3f 7.25f
>
>
> I need to be able to add the numbers together to give me 24.25, i.e. strip
> the fs away. The numbers will always be less than 10 and the there will
> only
> ever be .25 or.5 or .75 after the number (I don't know whether that is
> significant?).
>
>
> If anyone can show me how to do this I would be very grateful. I have been
> messing around with MID and FIND to no avail and then started thinking
> that
> SUMPRODUCT might have to get involved but it all got a bit much for me!
> There may be a perfectly simple solution which I have overlooked!
>
>
>
> Regards,
>
>
>
>
> Gavin
>
>


.

Quantcast