Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Select rows w/cells containing given character strings, then sum cell in two other col. Select rows w/cells containing given character strings, then sum cell in two other col.
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2017, 12:03 PM
LarryHills LarryHills is offline Select rows w/cells containing given character strings, then sum cell in two other col. Windows 8 Select rows w/cells containing given character strings, then sum cell in two other col. Office 2016
Novice
Select rows w/cells containing given character strings, then sum cell in two other col. 		 
Join Date: Feb 2017
Location: Lexington, KY
Posts: 1
LarryHills is on a distinguished road
Default Select rows w/cells containing given character strings, then sum cell in two other col.

I need a formula that will select rows containing cells w/given character string, then sum values in other cells in the same row. More info: I downloaded info from my broker that contains all activity in my stock account since 2010. If a cell in col. 'A' has a date < 08/25/2015 and cell in col. 'C' contains a given char string and a cell in col. 'F' contains a given string, then sum counts in col. 'I' and sum $$$ in col. 'K'. The IRS will need this info when I sell the stock.
Reply With Quote
  #2  
Old 02-17-2017, 03:55 PM
jeffreybrown jeffreybrown is offline Select rows w/cells containing given character strings, then sum cell in two other col. Windows Vista Select rows w/cells containing given character strings, then sum cell in two other col. Office 2007
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
Something like...

=SUMIFS(I2:I13,A2:A13,"<"&DATEVALUE("8/25/2015"),C2:C13,"ABC",F2:F13,"XYZ")
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select rows w/cells containing given character strings, then sum cell in two other col. If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
Select rows w/cells containing given character strings, then sum cell in two other col. Cell A1 Select car maker = Cell B1 shows menu for car models jaywizz1 Excel 1 03-11-2016 05:09 PM
Select rows w/cells containing given character strings, then sum cell in two other col. How can select from a specific character to another character mohsen.amiri Word 2 02-19-2015 11:38 PM
Select rows w/cells containing given character strings, then sum cell in two other col. Removing Character Strings digitalhecht Word 2 10-17-2011 12:53 PM
Select rows w/cells containing given character strings, then sum cell in two other col. update style of all strings available between two specific strings vikrantkale Word 1 03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 AM.

Contact Us - Privacy Statement - Top

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