Search Column For Text

[toy4x4]

Ok, here is what I am trying to do.

I have a spreadsheet with 27000 rows.

Column A is Text and Column B is a price. So what I need to do is search column A for the specific text of "value". If column A = "value" then I need to add the column b price in.

Example;

Column A Column B
Car $20000
Truck $20000
Truck $20000
Car $20000
Car $20000


So when i search Column A for "Car", I get a total of $60,000. When I search Column B for "Truck" I get $40,000.

 

[NBVC]

use Sumif()

e.g.

=Sumif(A:A,"Truck",B:B)

You can replace "Truck" with a cell reference housing the word.

 

[toy4x4]

Thanks as always for the quick help!!

 

[toy4x4]

use Sumif()

e.g.

=Sumif(A:A,"Truck",B:B)

You can replace "Truck" with a cell reference housing the word.

That worked great, another question though.

What if column B was text. So if the rows looked like the following:

A.........B
Car.....Toyota
Truck...Chevy
Truck...Ford
Car......Honda
Car......Ford

So now on a row if it says Car, I want the "Toyota" text.

 

[NBVC]

"Car" shows up 3 times in column A, each with a different make in column B. Do you want the 1st occurance?

e.g. =Vlookup("Car",A:B,2,0)