Number of books = sumproduct ((E4: e17 > =DATE(2004，7， 1))*(E4:e 17 & lt； =DATE(2004， 12，3 1)))

Book sales = sum product ((E4: e17 >); =DATE(2004，7， 1))*(E4:e 17 & lt； =DATE(2004， 12，3 1))*F4:F 17)

/Ge Biao _ Wang/blog/item/11f 21413a981c4f1c2ce7978.html.