Need formula to count number of books sold

G

Guest

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
 
G

Guest

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
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find last date of sold stock and sold price. 2
Count entries in the column translating to minutes. 5
Lookup between two books 2
With F1 value, look at A, if match or partial match return B 5
Search tab using indirect for number of times in a range 3
Lookup Formula 4
Need Formular for Multiple Critera condition 5
Count if or SumProduct 2

Top