Sum column values based on intersecting criteria in row and column

[rlbush2]

I know I can use SUMIF and direct reference to each column but I want to use some sort of intersecting index forumula to sum values in a column base on row and column criteria. Sample file attached. Thanks everyone~!

[Pepe Le Mokko]

Like a Pivot Table?

[MarvinP]

Hi,

In L17 put this formula
=SUMPRODUCT(--($A$3:$A$12="JIM"),--(B3:B12))

See the attached for this and another possible answer using Filters.

[Ghozi Alkatiri]

=sumproduct(($a$3:$a$12="jim")*($b$2:$e$2="val1")*($b$3:$e$12))

[Jonmo1]

You can still use Sumif
SAMPLE2.xls

[rlbush2]

Yes I want to basically do what the pivot table does using formula's that use lookups to reference the criteria. Also the output table needs to go on a separate worksheet.

[rlbush2]

Here is a better sample file with actual data. May help. I appreciate ya'll's suggestions so far.