Can you give some more details. Like how many account columns do you
have, from which column to which column, how many rows, are there
specific columns you want to only look into if so which ones? Which row
is your Header row? Which columns do you have your names into? Things of
that nature. In the meantime have a look at the formula below, you might
be able to adapt it to your specifications.

=SUMPRODUCT((Sheet2!$A$2:$A$20=$A2)*(Sheet2!$B$1:$ D$1<""),Sheet2!$B$2:$D$20)
whe
Sheet2!$A$2:$A$20 in the range with the list of names in sheet 2
A2 is the cell with the name you want to lookup in your lookup sheet
Sheet2!$B$1:$D$1 is your header row with account names
Sheet2!$B$2:$B$20 is the range with your values

if you want to add the values from a specific column then you would use
something like

=SUMPRODUCT((Sheet2!$A$2:$A$20=A2)*(Sheet2!$B$1:$D $1="acc1"),Sheet2!$B$2:$D$20)
acc1 would be an account name in B1, C1 or D1 of Sheet 2

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498989