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.
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.