Identifying and summing in adjacent columns
I have a spreadsheet from my publisher that lists in Column A the date, column B the number of books sold, returned, or comped, and in Column C, a S, R or C. I want to identify all of S entries, etc., and total the number of books in each category for the month. I am at a loss to figure out how to do this.
DKS
|