|
|
|
|
Thanks, this helped
Jai
"tonywig" wrote:
Something like this?
=IF(B2<C2,"-",SUMIF(C$2:C$4,B2,D$2:D$4))
Where vendor number is different to group, no value is summed.
Where vendor number = group (i.e. it is the first in a group or it is
not in a group) then sum everything for that group.
--
tonywig
------------------------------------------------------------------------
tonywig's Profile: http://www.excelforum.com/member.php...o&userid=18985
View this thread: http://www.excelforum.com/showthread...hreadid=381718
|