Re: Add numbers accross columns after stripping away text

Tech-Archive recommends: Speed Up your PC by fixing your registry

Can I ask what the "0&" does? I have tried the formula without it and in my
case it still works fine.



Regards,



Gavin



"N Harkawat" <nh@xxxxxx> wrote in message
news:%233pfbCWXFHA.2076@xxxxxxxxxxxxxxxxxxxxxxx
> =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