View Single Post
 
Old 06-11-2021, 10:23 AM
DKS DKS is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2021
Posts: 4
DKS is on a distinguished road
Default 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