You might also want to check on the Smartlist "Export Solutions" where you
can export your Smartlist Data right into an excel "template." That Template
can be a pivot table or can use the Subtotals part of Excel. Knowing a
little excel VBA can make this much more effective. When you have a
smartlist selected, click on the menu "Samrtlist" then go to "Export
Solutions." I don't know if you need to have Smartlist builder to use this.
It might be standard functionality