Microsoft Office Forums - View Single Post - [Solved] SUMIF with Or

Thread: [Solved] SUMIF with Or

View Single Post

Old

02-17-2017, 10:48 AM

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

Does with work for you in I31...

=SUMIF(G7:G16,G31,I7:I16)+SUMIFS(I7:I16,G7:G16,"<> "&G31,H7:H16,"Bob")

Reply With Quote