I'm such a neophyte when it comes to ADO I can't even tell if what I'm asking is essentially the same as other recent posts.

I've created a recordset from Excel cell data, no connection at all, just creating recordset from scratch.

I use recordset.Filter to get the records I want. Now I want to sum the values for a particular field (i.e. column).

Do I need to loop through every record and sum or is there an ADO command to do it?