The subtotals can be provided by the SUMIF function, or the SUMPRODUCT
function.

I think that SUMIF should be adequate for the task, SUMPRODUCT is a
little slower in calculation sometimes.

Please look the function up in help and let the forum know if you need
further help.

Regarding the automatic bolding, the FORMAT.CONDITIONAL FORMATTING tool
can accomplish this. Form your post it is not clear if you are already
aware of this. Please post back if you need further clarification.


---
Message posted from http://www.ExcelForum.com/