=SUMPRODUCT(--(--RIGHT(A1:A3,LEN(A1:A3)-1)))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"michael.beckinsale" wrote in message
oups.com...
Hi All,

Sorry for the vague header but l couldn't figure out a sutiable title.

I would like to know if there is a way to do this:

T1.25
L2.00
T0.25
--------
3.00 Total of column ignoring letter prefixes

If it makes it easier the prefixes could be suffixes instead. Spaces
or characters such as : # could be used to seperate the letters from
the figures.

This is required for a 'Resource Planner' that l am developing that is
required to span as many days as possible accross the columns so using
a helper column is not a practical option.

Additionally l would like to apply group sub-totals (preferably using
data/subtotals) and still have the column summed ignoring the letters.

Has anyone got any ideas please?

TIA

Regards

Michael Beckinsale