If I do not want to use VB then the way I do it is very simple. I create a criteria containing sales rep name on sheet2, then create a data range on sheet1. At the bottom or top of the sheet1 using DSUM function, I get the running total of each rep. See the attached example. I hope this will help. Thanks -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Dallas Stearns Sent: Tuesday, November 21, 2006 1:50 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Excel question. ok, I'm having an issue. I have tried everything I can think of- hopefully someone from this news group can help. I have a pretty simple excel spreadsheet. It's a sales tracking form. I have 2 sales reps that are assigned a number to identify them (one is 3310, and the other is 3303) I track all the sales they make. AND in the LAST column there is a "running total" from each rep. I have tried an "If" formula- and I can't make it work. Is there something someone might be able to suggest. I don't want thetotal to be the TOTAL sales- but rather a running total from each rep. thanks! Dallas ---------------------------------------------------------------------------- Get the latest Windows Live Messenger 8.1 Beta version. Join now.[1] --- Links --- 1 http://g.msn.com/8HMBENUS/2746??PS=47575 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* -- No attachments (even text) are allowed -- -- Type: application/vnd.ms-excel -- File: DSUM.xls ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************