how to modificate this function

[pinstripe]

=SUM(OFFSET(Start_point_present;MATCH($C25&Koda8;Item_bab&Kode8_bab;0); ;;MATCH(VLOOKUP(J$3;Present_past_range;2;FALSE);Present_range_data;0)))
{} - an arrey formula

hi,
this formula match item and code and month, then sums values(by month (if mar)then - jan+feb+mar)
.... but this one sums just 1 match (item, code)
how i need to modificate this formula to sum all values for all same items with same code?
thx in advance

[EdMac]

Try sumproduct

http://xldynamic.com/source/xld.SUMPRODUCT.html

Ed

[pinstripe]

Try sumproduct

http://xldynamic.com/source/xld.SUMPRODUCT.html

Ed

i did that also, several different methods with sumproduct - just couldn't find the right result (to sum columns ?)

[EdMac]

Hi,

You can't sum whole columns and the colums all have to be the same length,

If you post an example (as a zipped xcel file), I'm sure someone will be able to help you.

Ed