It may be easier to use a pivot table. Select your range of cells
including headers. Open the Pivot Table Wizard. Click Next. Click
Next. Click Layout. Drag your header Inspector to the Row section on
the left. Drag your Amount header to the Data section. Change that to
Sum by double clicking on it and picking Sum from the option list. Click
OK. Select the location for your Pivot Table and click Finish. You can
then hide the fields with blanks and totals in them.

When you dump in the new data, make sure your Pivot Table range is
large enough to capture all of the data and then Refresh the pivot
table. You may just want to set the range once to a size that you will
not exceed in the future. This will show any new Inspector ID's and the
amount totals once refreshed.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561171