D

#### Daniel

So I'm trying to make a formula that sums only certain values in a range of

cells. The problem is I need to manipulate each cell content before

testing/adding to the sum (but not do this permanently of course). For

example, if i have a range of 3 cells that contain the values "P90", "PHP",

"B60", I need my formula to sum the last two digits of only the values

starting with "P" and that have a number for the last two.

I haven't been able to get something like this to work, even for really

simple formulas like counting the number of cells whose right character is

numeric or summing the right characters of all cells in a range. Any

suggestions? Maybe i'm thinking of this from too much of a programming

perspective?

Thanks

Daniel