One way would be to use Custom BeginsWith BO2 on the AutoFilter, and then use the SUTOTAL function to get your total....... Vaya con Dios, Chuck, CABGx3 "RMT" wrote: I am using an old dos based program , and exporting data into Excel. Using Autofilter I am cleaning the rows that I don't need. However I need to add (Values) for several sub-categories (sub-total). e.g..

>From wehe@skeedaddy.com Fri Jul 13 00:06:54 2007 Return-Path: <wehe@skeedaddy.com> Received: from localhost ([192.168.0.3]) by dev.null.davjam.org with ESMTP id <AT$ifz4OQrlGBwyM@dev.null.davjam.org> for <dbolt@my-ste.demon.co.uk>; Fri, 13 Jul 2007 00:06:54 +0100 Received: from pop3.demon.co.uk by localhost with POP3 (fetchmail-6.2.5) for dbolt@my-ste.demon.co.uk (multi-drop); Fri, 13 Jul

>From gertrud@calibrelake.com Sun Mar 18 08:16:39 2007 Return-Path: <gertrud@calibrelake.com> Received: from localhost ([192.168.0.3]) by dev.null.davjam.org with ESMTP id <wh$OTnjnVP$FBwLr@dev.null.davjam.org> for <postmaster@my-ste.demon.co.uk>; Sun, 18 Mar 2007 08:16:39 +0000 Received: from pop3.demon.co.uk by localhost with POP3 (fetchmail-6.2.5) for postmaster@my-ste.demon.co.uk (multi