Microsoft Office Forums - View Single Post - [Solved] Index / Match / Vlookup - correct formulae

Thread: [Solved] Index / Match / Vlookup - correct formulae

View Single Post

Old

01-20-2017, 05:41 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

Here's one way...

In I3 copied over and down...

=SUMPRODUCT(--($C$3:$C$23=$H3),--($D$3:$D$23=I$2),$E$3:$E$23)

Another option is to use a pivot table

Reply With Quote