Peter,
I haven't tested it as I don't have the data clear in my mind, but try
=SUMPRODUCT(N(OFFSET(mod_Records_Filtered_AccountC odeCol,1,,43,)=
CashFlow_Primary!$E12)*
N(OFFSET(mod_Records_Filtered_AccountCodeCol,1,COL UMN(Records_Filtered!AC$1)
-COLUMN(mod_Records_Filtered_AccountCodeCol),43,)))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"PeterW" wrote in
message ...
Hi
When I check the below formula it seems to fall over because of the use
of the Column function.
SUMPRODUCT((
OFFSET(mod_Records_Filtered_AccountCodeCol,1,,43,) =
CashFlow_Primary!$E12)*
(OFFSET(mod_Records_Filtered_AccountCodeCol,1,COLU MN(Records_Filtered!AC$1)-
COLUMN(mod_Records_Filtered_AccountCodeCol),43,)))
Is it possible to use the Column function with Sumproduct??
Thanks in advance
Peter
--
PeterW
------------------------------------------------------------------------
PeterW's Profile:
http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=502377