ok i have changed course with this to make it a little bit more simple.
i have used SUMIF and COUNTIF functions as it shortens the formula down.
i am looking
In cell D21, i have tried to joing the CountIF and SumIF formulas together with the 2 vlookups, but i cant get it to work.
what i want it to do is: give me the average price of all 6160 printers sold in November 07.
also any pointers on improving the formula?
i have attached the file.
many thanks!