Formula based on Contents of Particular Cell

Forumla needed based on Contents of a Particular Cell, Eg If Cell A1 Contains Apple Then Add A2 A3 & A4.

Data Base

..............A (Name) ........B (Price) ..........C(Number Sold)...................D(Transport).............E(Total Cost)...........E (Apples Total)...........F(Orange Total)

Row 1 ......Apple .............. £1.00 .............. 5 .......... .............................£1.00 .......................£5.00 .............. £6.00 ............ ................£0.00

Row 2......Orange..............£1.00 .................1 ..........................................£1.00 ......................£2.00...................£0.00 ............................. £1.00

Row 3......Apple ..............£1.00 ................2 ..........................................£2.00.......................£4.00....................£2.00..............................£0.00
.


Im looking for a formula that is looking for a specific Name or Number in a colum prior to competing the forumla. For example, If you as above you ahve Colum A Name, B item price, C Number Sold, D Transport Cost, E Total Cost, F Item Apples, G Item Oranges

I would like a forumla in Colum F that Searches Colum A, If it finds the Text "Apple" it then uses standard Forumla to add up the Total Cost.

I am trying to use this to abstract information easliy from a database containing multiple jobs, Each job has a specific job number and is entered onto the database in date format, this also needs to show cumlative project value. I have been manualy copying a formula into this colum for only the specific jobs. I am sure you will agree that a specific forumla which searches the cell for a text or number value would be the best way to go.

Thanks in advance for all help!

Regards

Trevor