Hi Alvaro,

Am Thu, 6 Oct 2011 13:05:04 -0700 (PDT) schrieb Alvaro:

TOTAL
VENDOR INVOICE PAID PAID
A 100 4526
A 250 4625
A 578 4626 928
B 10 SC17
B 186 SC350 196
C 541 Inv 56
C 325 Inv 78
C 18 Inv 102 884

in D3:
=IF(A4=A3,"",SUMPRODUCT(--($A$3:$A$1000=A3),--($B$3:$B$1000)))
and fill down


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2