Select rows w/cells containing given character strings, then sum cell in two other col.

		Microsoft Office Forums > Microsoft Excel > Excel
Select rows w/cells containing given character strings, then sum cell in two other col.

02-17-2017, 03:55 PM

jeffreybrown jeffreybrown is offline

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

Something like...

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Cell A1 Select car maker = Cell B1 shows menu for car models	jaywizz1	Excel	1	03-11-2016 05:09 PM
How can select from a specific character to another character	mohsen.amiri	Word	2	02-19-2015 11:38 PM
Removing Character Strings	digitalhecht	Word	2	10-17-2011 12:53 PM
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 07:23 PM.