Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 06-11-2021, 10:23 AM
DKS DKS is offline Identifying and summing in adjacent columns Windows 10 Identifying and summing in adjacent columns Office 2016
Novice
Identifying and summing in adjacent columns
 
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
  #2  
Old 06-12-2021, 05:51 AM
macropod's Avatar
macropod macropod is offline Identifying and summing in adjacent columns Windows 10 Identifying and summing in adjacent columns Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

This is a duplicate of: https://www.msofficeforums.com/excel...t-columns.html
Kindly don't post questions about the same/related issue in multiple threads. Thread closed. You may continue the discussion in your other thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying and summing in adjacent columns Identifying and summing in adjacent columns DKS Excel Programming 4 06-11-2021 02:08 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
Identifying and summing in adjacent columns SUMMING TWO COLUMNS LOGISTICS1 Excel 1 04-18-2006 06:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft