Pick up and Calculate specific data

Hi,

I am trying to work out how I can pull some information from a massive data sheet. I need to find all the rows that return a specific value then pick up a value in the same row in another column, these then all need to be added together, a high number extracted, a low number extracted and an average caculated.

Example.
(the sheet has thousands of lines)
I need to pick up all the rows which have BMW in the make column get the information from the sales price column then work out the values just for BMW.

Any help would be fantastic.

Originally Posted by WLM1976

Hi,

I am trying to work out how I can pull some information from a massive data sheet. I need to find all the rows that return a specific value then pick up a value in the same row in another column, these then all need to be added together, a high number extracted, a low number extracted and an average caculated.

Example.
(the sheet has thousands of lines)
I need to pick up all the rows which have BMW in the make column get the information from the sales price column then work out the values just for BMW.

Any help would be fantastic.

VLOOKUP formula will do the job but you need to give details of data with sheet names and data structure with cell references in which it resides.

Could you please be more specific with your answer, my knowledge of Vlookups is that they pick up unique records and return a value in that row.
What i need to be able to do is pick up all the records sum the sales values and then select the high, low and average prices.

Originally Posted by WLM1976

Could you please be more specific with your answer, my knowledge of Vlookups is that they pick up unique records and return a value in that row.
What i need to be able to do is pick up all the records sum the sales values and then select the high, low and average prices.

it would be easy to understand if you attach here a file with sample data.