Hi everyone, I'm lucky enough to be in Excel 2007 and have infront of me 3 columns of data. As an example, in the first column is the colour of a product, 2nd = the price, 3rd column = quantity in stock. Now I know that I can use an array formula to come up with a way of finding out the number of red products that are £2 and have 2 items in stock - unfortunately I am not sure how to do this! Anybody have any tips/ways of doing this? Thanks so much if you're brave enough to answer!