Microsoft Office Forums - View Single Post - [Solved] Select rows w/cells containing given character strings, then sum cell in two other col.

Thread: [Solved] Select rows w/cells containing given character strings, then sum cell in two other col.

View Single Post

Old

02-17-2017, 03:55 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown 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