=SUMIF(D:D,F1,E:E)
--
tj
"Watercolor artist" wrote:
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
|