[mso] Re: Excel question.
- From: "Dallas Stearns" <dallas_1973@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 21 Nov 2006 16:34:09 -0600
I will attach one of the reports. The A/M is short for account manager-
there are two that I deal with- one with the number 3310, and the other
3303. The column next to that number is the OTB (short for ONE TIME BUY-
which is a term when a client comes in and purchases only one item that may
have been left off the inital order) The A/M still get's credit for it- but
my company doesn't track it- I have to. So i have 2 A/ms and for each OTB i
have to keep a running total. In the spreadsheet i sent- i have been
MANUALLY entering these values. I know that there has to be a way I can
makeit do it for me. That's why i asked the group. I color coded them to
show you what I mean. I have to arrange this by date- otherwise it would be
easy to do what I want if I could arrange by account manager.
Thank you soo much. ALSO- where can I find your book on excel?
Dallas
----------------------------------------------------------------------------
From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Reply-To: mso@xxxxxxxxxxxxx
To: <mso@xxxxxxxxxxxxx>
Subject: [mso] Re: Excel question.
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
emailmessages, read these instructions that explain why and how to fix it:
>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>*************************************************************
----------------------------------------------------------------------------
All-in-one security and maintenance for your PC. Get a free 90-day trial!
[1]
--- Links ---
1 http://g.msn.com/8HMAENUS/2752??PS=47575
-- No attachments (even text) are allowed --
-- Type: application/vnd.ms-excel
-- File: center sales tracking formTEST.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
*************************************************************
Other related posts:
