match - Sum a column in Excel based on two references in the column and two filter reference columns -

match - Sum a column in Excel based on two references in the column and two filter reference columns -

i need sum valumes of column, need identify column based on 2 values in column , have filter values in 2 adjecent columns.

here example:

reference1 act. act. act. ... bud. bud. bud. reference2 jan feb mar ... jan feb mar reference3 reference4 auto bluish 1 2 3 4 5 6 auto bluish 1 2 3 4 5 6 auto reddish 1 2 3 4 5 6

so, have add together auto & bluish & act. & jan = 1+1 = 2. , other columns.

i accomplish follows:

reference3 reference4 reference1 reference2 value auto bluish act. jan 2 auto bluish act. feb 4

the problem have formula utilize in value column above. can not sumifs columns in original source table change. vlookup don't work there no single column lookup_value. thought using match identify column, have 2 references(1&2) doesn't work either.

any ideas on formula(s) utilize achive above.

thanks

try making pivot table info (this not create formulas, though, nevertheless give desired results).

here simple guide on doing in excel 2003 - http://www.techonthenet.com/excel/pivottbls/create.php

excel match vlookup sumifs