Yes, I am getting you, but the pivot table, array formulae, D-function
and subtotal methods will all give you the totals you seem to need. Have
you tried them?

Bearing in mind you seem to be getting new data  straight from a
recordset, I'd use either subtotals or the pivot table, since either can
be set up in just a few seconds.