Formula to make "word" equal "numeric value"

For the Formula based answer make sure the cells in that row are the the Currency Format>Select Cell Range. (H4:H34) in you case.
For your specific situation

Solution #1

=IFERROR(SUM(IF(B4="Subway",VALUE(SUBSTITUTE(B4,"Subway","$4.30")),IF(B4="Bus",VALUE(SUBSTITUTE(B4,"Bus","$3.90")),"")),IF(G4="Subway",VALUE(SUBSTITUTE(G4,"Subway","$4.30")),IF(G4="Bus",VALUE(SUBSTITUTE(G4,"Bus","$3.90"))))),"")

After you have completed this, drag and fill the formula all the way down.

Function Explanations

IFERROR

IFERROR(FUNCTION_OR_FUNCTIONS,RESULT_IF_FUNCTION(S)_RETURN_AN_ERROR_CODE)

SUM

=SUM(

IF

=IF(TEST,IF_TRUE,IF_FALSE)

VALUE

=VALUE(TEXT_STRING)

SUBSTITUTE

=SUBSTITUTE(CELL_REFERENCE,TEXT_TO_REPLACE,TEXT_TO_REPLACE_ORIGINAL_TEXT,[NUMBER_OF_TIMES_TO_REPLACE_OLD_TEXT])

Section of code enclosed with [] defaults to all instances of "Subway" within the referenced Cell.

Evaluation of the Separate Functions
The VALUE function changes text into a number format

=VALUE()

The text can be manually entered: "$4.30"

or

The text can be referenced by address: B4
(Since 'B4' is still text, the value function still needs to replace the text with the desired number.)

So...

Inside the VALUE Function, the SUBSTITUTE function changes your text into the appropriate number.
Part 1,

=SUBSTITUTE(B4,

Targets Cell Address B4.

Friendly Reminder:Remember to use $ to lock column or row ($B4/B$4/$B$4), if you want to repeat the result of specific cells or Absolute Locations.
Not that I could foresee why you would want to.



Part 2,

"Subway",

Looks for the word Subway.
The text within the quotes is case sensitive.


Part 3,

"$4.30"

Changes the text Subway into $4.30
(Which gives VALUE a text number, to convert into a Value that it can use mathematically.)

Part 4,

,2)

The number 2, will look for "Subway" two times within the referenced cell (B4)
But, we don't this this particular bit of information.

So the finished product of this function is...

=SUBSTITUTE(B4,"Subway","$4.30")

Note that part 4 is absent

And that is the long answer to your problem.

A simpler but less versatile code, as it requires a single match (Though it should work for your purposes.

Solution #2

=IF(B4="Subway",$4.30,IF(B4="Bus",$3.90,0))+IF(G4="Subway",$4.30,IF(G4="Bus",$3.90,0))

An easier way still would be to Put the words into separate cells, and reference them in the formulas, instead of the direct words.

Solution #3

L1="Subway"

L2="Bus"

=IF(B4=$L$1,4.3,IF(B4=$L$2,3.9,0))+IF(G4=$L$1,4.3,IF(G4=$L$2,3.9,0))

Alternatively, if you prefer the sum function, use as per normal with the contained if statements in either of the above.

Thank you! should I delete the posts which I quoted?

Hey Pedro. The reason you weren't successful seems to be that you didn't match the case of the word.
If the Plan in cell B4 says "SUBWAY" then any SUBSTITUTE function also needs to say "SUBWAY"
If Cell B4 says "subway" then function should match with "subway"
and also "SuBwAy" should read "SuBwAy" inside the SUBSTITUTE function.

Hope that helps.

At the top of the Thread, above your post and to the right, there is a link "Thread Tools". Click it to open a menu and select "Mark thread as Solved."

how do I mark this as solved? and what else should I do ? I have gaven all of you good reputation if that helps with anything!

Glad to help! We all have to start somewhere. I started by working with the help function (Hotkey: F1) and the IF() function. Good luck!