[mso] Re: Excel question.
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 21 Nov 2006 17:10:44 -0500
I'm assuming their number appears on each row that shows their sales? And,
that the number is always in the same column?
You can sum all the sales that refer to each salesman's number, either by
creating a table and using the DSUM function, but it might be easier to just
do it as an array formula.
Read this article I wrote on array formulas and see if this gives you what
you need:
http://personal-computer-tutor.com/arrayformulas.htm
You need to see the part which shows you how to sum something in Column A,
based on what is in Column B
Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Dallas Stearns
Sent: Tuesday, November 21, 2006 3: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
*************************************************************
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
*************************************************************
Other related posts:
