Suming

[Joshdube]

Hi there, I have a quick question..

http://img339.imageshack.us/img339/9107/excelir8.png

How would I make cell F7 show the total price of all of the Ferrari's situated in cells C7 and 8? But I don't want this =SUM(C7:C15), I want it so that if I sort the make and price the F7 wont change.

This is only an example, but please give me the code for cell F7 that I would need.

If you still don't understand my question, post below for clarification.

Thank you

Josh

[NBVC]

Try:

=Sumif(B7:B15,"ferrari",C7:C15)

[BigBas]

Clarify: Do you want cell F7 to always show the sum of Cells C7 and C8, or do you want cell F7 to always show the price of all the Ferraris in cells C7:C15?

[Joshdube]

Clarify: Do you want cell F7 to always show the sum of Cells C7 and C8, <b>or do you want cell F7 to always show the price of all the Ferraris in cells C7:C15?</b>

Thats it.

So if I sort the prices and makes the price will stay the same in F7

Josh

PS the code given to me works actually, so thank you.