vlook up and adding the 2 vlookup formulas (1 Viewer)

[rvd48]

hi,

this is a progression from a previous thread with a thankyou to Helicopter's help

EDIT: see 2nd post below.

thanks

 

[rvd48]

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!

 

[unmarkedhelicopter]

Cross posted to Ozgrid http://www.ozgrid.com/forum/showthread.php?t=82641