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

Please take a few minutes to reread the forum rules, and then amend your thread title accordingly.

Use the Edit button,then select Go Advanced

I think you are looking for SUMIF

e.g.

=IF($A$1:$A$10,"Apple",$B$1:$B$10)

this sums B1:B10 where A1:A10 contains "Apple"

Adjust cells and references as necessary

Note: You can replace "Apple" in formula with a cell reference containing the word to search.

Is this on a line per line basis.. or are you wanting to multiply all occurences of Apple and corresponding B*C+D to get a grand total..

so if Apple appears more than once in your list column F will have the same repeated result?

or do you simply want:

=IF(A2="Apple",($B2*$C2)+D2,0) copied down.