Assuming your data is in Column A starting in Row 1, you can get your total
using this array-entered** formula...

=SUM(IF(A1:A1000<"",--LEFT(A1:A1000,FIND("-",A1:A1000)-1),0))

You can change the maximum possible row number from the 1000 I used to
whatever value you want.

** NOTE...
Commit the above function using Ctrl+Shift+Enter and NOT just Enter by
itself.

Rick


"Princess Caroline" wrote in
message ...
Ok, I got this to work. Wonder if I could actually remove the -B or -P
from
the number so I can total the number?

"RagDyer" wrote:

You can create a "helper" column, where you extract the last letter, and
then sort both columns together, using the helper column as the sort key.

Say your data was in Column A.

In B1 enter this formula:

=Right(A1)

And then copy down as needed.

You might try *double* clicking on the fill handle (little black square
in
the lower right corner of a *selected* cell).

This will *automatically* copy the formula in B1 down Column B, as far as
there is data in Column A.

Now select both columns, and sort on Column B.


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Princess Caroline" wrote in
message ...
I've got data that includes a variable. Either -B or -P. I need to
sort
on
this variable.
348.00-P
113.20-P
2023.90-B
411.00-B
504.00-B
135.00-P

Simple explaination, please. I don't really speak Excel language very
well...
Thanks