Thanks Harlan... that is perfect. I figured out it was returning the
array, just couldn't work out the way to turn the array into a number..
seems obvious in hindsight.
Also, many thanks Bob for your suggestions
The final working formula is
SUMPRODUCT((
OFFSET(mod_Records_Filtered_AccountCodeCol,1,,43,) =
CashFlow_Primary!$E12)*
(OFFSET(mod_Records_Filtered_AccountCodeCol,1,SUM( COLUMN(Records_Filtered!AC$1)-COLUMN(mod_Records_Filtered_AccountCodeCol)),43,)) ))
--
PeterW
------------------------------------------------------------------------
PeterW's Profile:
http://www.excelforum.com/member.php...fo&userid=6496
View this thread:
http://www.excelforum.com/showthread...hreadid=502377