Identifying and summing in adjacent columns

DKS · #1 06-11-2021, 10:16 AM

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

Purfleet · #2 06-11-2021, 10:46 AM

Please provide an example

DKS · #3 06-11-2021, 12:15 PM

I have attached the spreadsheet. The summary spreadsheet just counted the occurrence of S in the column and is incorrect.

David

Purfleet · #4 06-11-2021, 01:50 PM

Is this what you are after?

DKS · #5 06-11-2021, 02:08 PM

Yes. many thanks/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vertical Text Alignment with Adjacent Columns	kdutrisac	Word Tables	2	06-26-2017 12:38 PM
Performing calculations on non adjacent columns	Radtastic10	Excel Programming	4	06-07-2017 05:47 AM
Help with summing across columns please	jdsg0	Excel	21	03-20-2017 02:28 PM
New Cost columns are not summing up.	elvanaguven	Project	3	11-08-2014 02:28 PM
SUMMING TWO COLUMNS	LOGISTICS1	Excel	1	04-18-2006 06:00 AM