Hi All,

I have rows of data, but basically, I want to build up a query (via list in validation) which will enable users to get "Statistics" from the data held.

Column C = Number (any number between 1 - 1000)
Column D = Stage Number (between 1 - 5)
Column E = Open/Closed validation list.

Example :
419 ~ 4 ~ Closed

At the top of the sheet I have built an option...where users can enter a number (between 1 - 1000) in 1 cell, Select a stage via validation in the next cell, and select Open/Closed via validation list.

So...i need (and i think it will be sum product) where when users select 419 ~ 4 ~ Closed, it will search the data and display the number that meet the criteria.

I hope I havnt made this sound much harder that it actually seems...

Any advice will be greatful.

Thanks in advance.

Emma x