getting the total from the result of the formula

sorry for the title, but i cant think of better title, so here we go. I have already an existing formula to get only the amount from the previous cell. From a6 to a30 it contains the word "11/05/09 press release $100", so in b6-b30 this is the formula.

=IF(ISNUMBER(SEARCH("press",A6)),RIGHT(A6,LEN(A6)-FIND("$",A6)),"") until b30


the problem is in b6:b30 the 100's were not a number you have to copy and paste to other cells using paste special then values then click the smart tag and convert as a number to get all the total from b6 until b30.


is there a better way to get the total of those amount without doing those steps?


Thanks!

Just add +0 to the end of the formula to convert the result into a real number.

=IF(ISNUMBER(SEARCH("press", A6)),RIGHT(A6, LEN(A6) - FIND("$", A6)), "") + 0

This change will return numeric results.. Is this what you mean?

=IF(ISNUMBER(SEARCH("press",A6)),RIGHT(A6,LEN(A6)-FIND("$",A6))+0,"")

Aww... don't laugh. It is always easy when you already know how. This is the first time you've faced this issue so it comes as a bit of an enigma, as it does for many (it did for me).

Now that I've been through it, I instinctively know to do this, and now you will, too!

Go team!

Moral of the Story: "Ask the forum sooner."



EDIT:
Remember the Left/Right alignment of values in cells is meant to remind you what kind of data it is. If you see 1234 but it is aligned LEFT, it is text (barring any fancy formatting, that is).