What's wrong with simply using:

=SUMPRODUCT((A1:A100=1000)*B1:K100)

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"VBA Noob" wrote in
message ...

Or how about


=SUMPRODUCT(--($A$1:$A$56=1000)*($A$1:$A$56)+(--($A$1:$A$56=1000)*($B$1:$B$5
6)+(--($A$1:$A$56=1000)*($K$1:$K$56))))


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561845