Hi there,

can even evolve it, replacing the "12" in the middle to a cell reference
c2: = SUMIF( B:B;a2;A:A)
C3: = SUMIF(C:C;a3;A:A) etc.

best regards,
ANdras
(Hungary)

"yozzdi" wrote:


Thanks! This works great.


--
yozzdi
------------------------------------------------------------------------
yozzdi's Profile: http://www.excelforum.com/member.php...o&userid=30376
View this thread: http://www.excelforum.com/showthread...hreadid=532909