Here's one way

=SUM((A1:A20=TRANSPOSE(MyList))*(B1:B20))

with the list called MyList, needs to be entered with ctrl + shift & enter



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Matizka" wrote in
message ...

Hi,

I need to sum all of the values for columns that are called: :A, B, C,
D.

I would like to use something like "in list " operand that are in some
othe programs. How should I write it?

Sorry if it is an obvious or recently asked questions I did some search
on the forum but I haven't found an answer.

Thanks in advance,

M.


--
Matizka
------------------------------------------------------------------------
Matizka's Profile:
http://www.excelforum.com/member.php...o&userid=24098
View this thread: http://www.excelforum.com/showthread...hreadid=519723