Need formula to count number of books sold
 

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

=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

=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

Anne,

If I enter the formula as you have it, I get an error message. I need to
enter it as =sumif(D:D,f1,E:E).

Howard

"Anne Troy" wrote:

=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

Thanks, it worked. I assume it means check the values in column D. If any
match what's in F1, sum the matching value in column E. Is that correct?

"tjtjjtjt" wrote:

=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