=sumif(D:D,=f1,E:E)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Watercolor artist" wrote in
message ...
Column D contains the books that were sold during a month. A book can
appear
more than once. Column E contains how many of the book were sold.

Example:

Col. D. Col. E
a 5
b 3
b 4
c 1
d 7

I need a formula that will use the value in Cell F1 (Cell F1 will contain
the name of the book I want to count) and then tell me how many copies of
that book were sold. So, for book b it would return 7.

Thanks,
Howard